Hi
I'm trying to install HIVE on Hadoop version 1.0.2.
I use hive-0.11.0.tar.gz version. Hive successfully gets installed and when i
try to run a HIVE command, say SHOW TABLES; i get the following error,
hive show tables;
Exception in thread main java.lang.NoSuchFieldError: type
at
Its not just the antlr, there must be no conflicting jars on HADOOP_CLASSPATH
versus that required by your hive version.
Thanks
Rekha
From: Ranjitha Chandrashekar ranjitha...@hcl.commailto:ranjitha...@hcl.com
Reply-To: user@hive.apache.orgmailto:user@hive.apache.org
Hi Rekha
Thanks for the quick response.
Figured out the issue. This was because of the conflicting antlr jar.
This is caused due to wrong resolution of antlr runtime.
Instead of resolving from HIVE_HOME/lib/antlr*jar - it was resolving from
HADOOP_HOME/lib/mahout-examples-0.7-job.jar
The
Raj,
You should dump the data in a temp table first and then move the data into
final table with select query.
Select date(), c1,c2. From temp table.
Reason: we should avoid custom operation in load unless it is necessary.
Sent via Rocket from my HTC
- Reply message -
From: Raj
How about this ?
Assume you have a log file called
oompaloompa.log
TIMESTAMP=$(date +%Y_%m_%d_T%H_%M_%S);mv oompaloopa.log
oompaloopa.log.${TIMESTAMP};cat oompaloopa.log.${TIMESTAMP}| hdfs dfs -put -
/user/sasubramanian/oompaloopa.log.${TIMESTAMP}
This will directly put the file on HDFS and u
Hi Hive Gurus,
I have a table with a bunch of columns and another table with a list of columns
names coming from the first table. What I want to do is to generate a 2-column
table that contains column-value pairs from the 1st table but only for columns
defined in the second table.
In other