RE: Hive index error

Hi Mark, I'm using single node Hive installation with all settings default. Yes, the table is partitioned on the column comp_code. Regards, Omkar Joshi From: Mark Wagner [mailto:wagner.mar...@gmail.com] Sent: Thursday, August 01, 2013 11:15 PM To: user@hive.apache.org Subject: Re: Hive

Hive index error

D REBUILD; FAILED: Error in metadata: java.lang.RuntimeException: Check the index columns, they should appear in the table being indexed. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask I checked this<https://issues.apache.org/jira/browse/HIVE-4251> issue but I d

RE: Hive - external (dynamically) partitioned table

Hi Dean, Thanks for the inputs ! I guess have to go by the tedious/hard way :P Regards, Omkar Joshi From: Dean Wampler [mailto:deanwamp...@gmail.com] Sent: Friday, July 26, 2013 4:26 PM To: user@hive.apache.org Subject: Re: Hive - external (dynamically) partitioned table Hive doesn&#

Hive - external (dynamically) partitioned table

Time taken: 0.599 seconds select count(1) from nas_comps; returns 0 records How do I create an external Hive table with dynamic partitions? Regards, Omkar Joshi The contents of this e-mail and any attachment(s) may contain confidential or privileged informatio

RE: Export to RDBMS directly

I read of the term 'JDBC Storage Handler' at https://issues.apache.org/jira/browse/HIVE-1555 The issues seems open but I just want to confirm that it has not been implemented in the latest Hive releases. Regards, Omkar Joshi From: Bertrand Dechoux [mailto:decho...@gmail.com] Sent

Export to RDBMS directly

ng if it would be possible to combine steps 2 & 3 - the output of the Hive query written directly to the MySQL database. I read about the external tables but couldn't find an example where the LOCATION clause points to something like jdbc:myql://localhost:3306//. Is it really possible?

Strange behaviour - CLI versus JDBC client over HiveServer2

ger (org.apache.thrift.transport.TSaslTransport). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. connected started- DB Product Name : Hive Driver Name : Hive The count is 0 Regards, Om

Hive Web interface start-up issue

.11.0$ find . -type f -exec grep -l "hive.hwi.war.file" {} + ./src/conf/hive-default.xml.template ./src/hwi/build.xml ./src/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java ./conf/hive-default.xml.template What can be the issue? Regards, Omkar Joshi

RE: Import from MySQL to Hive using Sqoop

Hi Nitin, Thanks for the inputs - will try out those. Regards, Omkar Joshi From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Thursday, June 27, 2013 11:48 AM To: user@hive.apache.org Subject: Re: Import from MySQL to Hive using Sqoop Disclaimer: I am not a sqoop guru so here are just

Import from MySQL to Hive using Sqoop

e table -> ALTER Non-partitioned Hive table to add PARTITION The syntax dictates to specify partitions as key value pairs - not feasible in case of millions of records where one cannot think of all the partition key-value pairs Can anyone provide inputs for approaches 2 and 3

Difficulties in executing lag function

:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) While the syntax error may be the reason, is there another cause? Regards, Omkar Joshi The contents of this e-mail and any attachm