: 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
From: Clay McDonald
Sent: Thursday, June 19, 2014 9:17 AM
To: user
Subject: simple insert query question
hi all,
how do I write the following query to insert a note with a current system
timestamp?
I tried the following;
INSERT INTO TEST_LOG VALUES (unix_timestamp(),'THIS IS A TEST.');
thanks, Clay
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
hi all,
how do I write the following query to insert a note with a current system
timestamp?
I tried the following;
INSERT INTO TEST_LOG VALUES (unix_timestamp(),'THIS IS A TEST.');
thanks, Clay
