Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: How to set default value for a certain field?


Copy link to this message
-
Re: How to set default value for a certain field?
Yep. It's not an ideal solution, but it gets you part of the way there.
Hive doesn't have a way of specifying default values at schema level.

Phil.
On Sep 5, 2012 11:38 PM, "MiaoMiao" <[EMAIL PROTECTED]> wrote:

> You mean COALESCE(value,3)? This does work on int field, and easier than IF
>
> select value,COALESCE(value,3) from testtest;
> 1       1
> 1       1
> 2       2
> NULL    3
> NULL    3
>
> On Wed, Sep 5, 2012 at 7:52 PM, Philip Tromans
> <[EMAIL PROTECTED]> wrote:
> > You could do something with the coalesce UDF?
> >
> > Phil.
> >
> > On Sep 5, 2012 12:24 AM, "MiaoMiao" <[EMAIL PROTECTED]> wrote:
> >>
> >> I have a file whose content is:
> >> 1,1
> >> 2,1
> >> 3,2
> >> 4,
> >> 5,
> >> Then I import in into a hive table.
> >> create external table testtest (id int,value int) row format delimited
> >> fields terminated by ',' stored as textfile location '/wtt/test/def';
> >> select * from testtest;
> >> 1       1
> >> 2       1
> >> 3       2
> >> 4       NULL
> >> 5       NULL
> >>
> >> I want to set default value for value, but seems hive simply doesn't
> >> have this feature, any idea?
> >> 1       1
> >> 2       1
> >> 3       2
> >> 4       3
> >> 5       3
>