What about if I wanted to run this in hive, 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 To: user@hive.apache.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 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.mcdon...@bateswhite.com<mailto:stuart.mcdon...@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
