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?
MiaoMiao 2012-09-06, 04:10
Thank you all, guess I just have to do it this way.

On Thu, Sep 6, 2012 at 11:50 AM, Philip Tromans
<[EMAIL PROTECTED]> wrote:
> 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