hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nishant Kelkar <nishant....@gmail.com>
Subject Re: simple insert query question
Date Thu, 19 Jun 2014 13:28:57 GMT
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 command to append a line to text file. It will automatically
reflect in your external Hive table! :)

To understand what Hive external tables are and how to create them, I'd
just go on the Hive wiki page.

Good luck!

Best,
Nishant
On Jun 19, 2014 6:17 AM, "Clay McDonald" <stuart.mcdonald@bateswhite.com>
wrote:

>  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
>

Mime
View raw message