Hive Authentication using Active Directory

Hi Everyone. I am sorry to bother you all with this issue, but I have been trying to solve the issue for 2 weeks now, and I am nowhere closer to finding a solution. I am running a cluster with Hadoop 2.2.0 Hive version 0.11.0.2 [ HiveServer2 ] I am trying to do Hive Authentication using

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

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

RE: simple insert query question

also, this does not work; insert into table test_log values(now(),'THIS IS A TEST'); insert into table test_log values(unix_timestamp(),'THIS IS A TEST'); insert into table test_log values (from_unixtime(unix_timestamp()),'THIS IS A TEST'); -Original Message- From: Clay McDonald

mismatched input 'EOF' expecting FROM near 'CURRENT_TIME' in from clause

Why does this not work? hive SELECT CURRENT_TIME; MismatchedTokenException(-1!=107) at org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617) at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115) at

Re: mismatched input 'EOF' expecting FROM near 'CURRENT_TIME' in from clause

Please take a look at hive's query language support. its pro-sql but not fully sql compliance On Thu, Jun 19, 2014 at 7:19 PM, Clay McDonald stuart.mcdon...@bateswhite.com wrote: Why does this not work? hive SELECT CURRENT_TIME; MismatchedTokenException(-1!=107) at

RE: simple insert query question

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

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 having just single record kind of stuff (as of now, this will change once hive starts supporting ACID actions in coming releases) 1) either create a sample file

RE: simple insert query question

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 storage

Rebuild HCatalog

Hi! I have install a couple of patches against HCatalog 0.12.0 and need to rebuild it. However, I am new to HCatalog and Hadoop. Can someone show me the necessary command to rebuild HCatalog? We have CDH5 installed. Carlotta Hicks carlotta.hi...@sas.com SAS(r) ... THE POWER TO KNOW(r)

Storage handler guidance

I haven't been able to find an explicit reference, hoping some one can clarify for me: Do storage handler reads/write get executed as parallel resources, i.e., in an INSERT...SELECT... from a storage handler, will multiple storage handler instances be created to read from the data source (using

Re: Rebuild HCatalog

Hi Carlotta, There are some instructions here on building from source, do they help? https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-BuildingHivefromSource Thanks Szehon On Thu, Jun 19, 2014 at 12:42 PM, Carlotta Hicks carlotta.hi...@sas.com wrote: Hi! I