esday, February 23, 2016 1:26 PM
*To:* user@hive.apache.org
*Subject:* Re: How to set default value for a certain field
Any idea on below requirement.
On 2/19/2016 2:47 PM, mahender bigdata wrote:
Hi,
is there Ideal solution in Hive to specify default values at
schema level. Currently we are
“null defined as” is what we use
From: mahender bigdata [mailto:mahender.bigd...@outlook.com]
Sent: Tuesday, February 23, 2016 1:26 PM
To: user@hive.apache.org
Subject: Re: How to set default value for a certain field
Any idea on below requirement.
On 2/19/2016 2:47 PM, mahender bigdata wrote
Any idea on below requirement.
On 2/19/2016 2:47 PM, mahender bigdata wrote:
Hi,
is there Ideal solution in Hive to specify default values at schema
level. Currently we are using *COALESCE *operator in converting null
values to default value, this would require reading entire table. But
it w
Thank you all, guess I just have to do it this way.
On Thu, Sep 6, 2012 at 11:50 AM, Philip Tromans
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, "Miao
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" wrote:
> You mean COALESCE(value,3)? This does work on int field, and easier than IF
>
> select value,COALESCE(v
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
NULL3
NULL3
On Wed, Sep 5, 2012 at 7:52 PM, Philip Tromans
wrote:
> You could do something with the coalesce UDF?
>
> Phil.
>
> On Sep 5
COALESCE how?
COALESCE(VALUE) will return VALUE or null.
I know this query works
select IF(VALUE is NULL,3,VALUE) from testtest;
But I have to do this conditional check on every possible field, every
time I perform queries. I mean, does Hive have something like
CREATE TABLE table (field INT NOT N
Select id, case when value = ‘’ then 3 else value end as value
>
> From testtest;
>
>
>
> Carla
>
>
>
> From: ext Philip Tromans [mailto:philip.j.trom...@gmail.com]
> Sent: Wednesday, September 05, 2012 07:52
> To: user@hive.apache.org
> Subject: Re: How to
7:52
To: user@hive.apache.org
Subject: Re: How to set default value for a certain field?
You could do something with the coalesce UDF?
Phil.
On Sep 5, 2012 12:24 AM, "MiaoMiao" mailto:liy...@gmail.com>>
wrote:
I have a file whose content is:
1,1
2,1
3,2
4,
5,
Then I import in into a hive
You could do something with the coalesce UDF?
Phil.
On Sep 5, 2012 12:24 AM, "MiaoMiao" 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 ',' s
10 matches
Mail list logo
