Hi all,
I'm looking to set a variable in Hive and use the resulting value in a
subsequent query. Something like:
set startdt='select max(dt) from sometable';
select * from someothertable where dt=${hiveconf:startdt};
I found this is still open
Consider using dataformat other than TEXT such as sequence file.
On Mon, Jan 12, 2015 at 10:54 PM, 王鹏飞 wpf5...@gmail.com wrote:
Thank you,maybe i didn't express my question explicitly.I know the hive
create table clause,and there exists FIELDS TERMINATED BY etc.
For example,if i use FIELDS
Any one has insights on the following issue? Where would be the best place to
make the changes? I have tried several approaches but it breaks some other
queries.
Basically, the inner query produces some additional columns (from window
function) not consumed by the outer query. The query plan
I have a table that I would like to define to be bucketed, but I also need to
write
to new partitions using HCatOutputFormat (or similar) from an MR job. I’m
getting
an unsupported operation error when I try to do that. Is there some way to make
this work?
I suppose I could write to a temporary
select * from someothertable where dt IN (select max(dt) from sometable);
On Tue, Jan 13, 2015 at 4:39 PM, Martin, Nick nimar...@pssd.com wrote:
Hi all,
I'm looking to set a variable in Hive and use the resulting value in a
subsequent query. Something like:
set startdt='select max(dt)
Can you give me a simple example like table only contains one string
column,and in that sting column it contains '\n' as the content ?
On Wed, Jan 14, 2015 at 1:42 AM, Xuefu Zhang xzh...@cloudera.com wrote:
Consider using dataformat other than TEXT such as sequence file.
On Mon, Jan 12, 2015
please try the following and report observation:
WHERE long = CAST(-41.338276 AS FLOAT)
regards
Devopam
On Tue, Jan 13, 2015 at 2:25 PM, Patcharee Thongtra
patcharee.thong...@uni.no wrote:
Hi,
I have a table with float columns. I tried to query based on the condition
on a float column
Hi,
I have a table with float columns. I tried to query based on the
condition on a float column (called 'long'), but it failed (nothing
returned).
hive select * from test_float where long == -41.338276;
select * from test_float where long == -41.338276
Status: Finished successfully
OK
Time
It works. Thanks!
Patcharee
On 01/13/2015 10:15 AM, Devopam Mittra wrote:
please try the following and report observation:
WHERE long = CAST(-41.338276 AS FLOAT)
regards
Devopam
On Tue, Jan 13, 2015 at 2:25 PM, Patcharee Thongtra
patcharee.thong...@uni.no mailto:patcharee.thong...@uni.no