Re: Add few record(s) to a Hive table or a HDFS file on a daily basis

Why not INSERT INTO for appending new records? a)load the new records into a staging table b)INSERT INTO final table from the staging table On 10-Feb-2014 8:16 am, "Raj Hadoop" wrote: > > > Hi, > > My requirement is a typical Datawarehouse and ETL requirement. I need to > accomplish > > 1) Daily

Add few record(s) to a Hive table or a HDFS file on a daily basis

Hi, My requirement is a typical Datawarehouse and ETL requirement. I need to accomplish 1) Daily Insert transaction records to a Hive table or a HDFS file. This table or file is not a big table ( approximately 10 records per day). I don't want to Partition the table / file. I am reading a

How to use hive api monitor hive job

Hi all How to use Hive API, monitor running Hive jobs yankunhad...@gmail.com

Re: Finding Hive and Hadoop version from command line

I like: hive version: $ schematool -info -dbType hadoop version: $ hadoop version Lefty recently plugged schematool not long ago so props to her on that one. Under the covers you'll see that it's a shortcut for hive --service schemaTool which is the official way to run it. Either way will do

Finding Hive and Hadoop version from command line

All, Is there any way from the command prompt I can find which hive version I am using and Hadoop version too? Thanks in advance. Regards, Raj

RE: NULL values and != operations

Look here : https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-RelationalOperators If one the sides of != is NULL, the results is NULL (not true, but not false also) From: Blaine Elliott [mailto:bla...@chegg.com] Sent: Wednesday, February 05, 2014 8:50 PM To: