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