: Nitin Pawar [mailto:nitinpawar...@gmail.com]
Sent: 19 June 2014 15:08
To: user@hive.apache.org
Cc: Nishant Kelkar
Subject: Re: simple insert query question
remember in hive, insert operation is
1) from a file
2) from another table
hive's underlying storage is hdfs which is not meant for h
Got it. Thanks!
From: Nitin Pawar [mailto:nitinpawar...@gmail.com]
Sent: Thursday, June 19, 2014 10:08 AM
To: user@hive.apache.org
Cc: Nishant Kelkar
Subject: Re: simple insert query question
remember in hive, insert operation is
1) from a file
2) from another table
hive's underlying st
> create table test_log (test_time timestamp, test_notes varchar(60));
>
>
>
> insert into table test_log values(now(),'THIS IS A TEST');
>
>
>
>
>
> *From:* Nishant Kelkar [mailto:nishant@gmail.com]
> *Sent:* Thursday, June 19, 2014 9:29 AM
>
.org; Clay McDonald
Subject: Re: simple insert query question
Hey Stuart,
As far as I know, files in HDFS are immutable. So I would think that your query
below would not have a direct Hive conversion.
What you can do though, is create a local text file and then create an EXTERNAL
TABLE on t
also, this does not work;
insert into table test_log values(now(),'THIS IS A TEST');
insert into table test_log values(unix_timestamp(),'THIS IS A TEST');
insert into table test_log values (from_unixtime(unix_timestamp()),'THIS IS A
TEST');
-Original Message-
From: Clay McDonald
Sent:
Hey Stuart,
As far as I know, files in HDFS are immutable. So I would think that your
query below would not have a direct Hive conversion.
What you can do though, is create a local text file and then create an
EXTERNAL TABLE on top of that. Then, instead of your INSERT query, just use
some linux
