Hive Installation Issue

2013-07-05 Thread Ranjitha Chandrashekar
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

RE: Hive Installation Issue

2013-07-05 Thread Ranjitha Chandrashekar
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 user@hive.apache.orgmailto:user@hive.apache.org Date: Friday 5 July 2013 2:52 PM To: user

Complex DataTypes in Hive

2013-04-10 Thread Ranjitha Chandrashekar
Hi How does hive interpret the complex datatpes (my own class) in the sequence file, say i have my own complex datatype (my own class) as the value written in the Sequence File. How do I make Hive read this, read it as corresponding columns. For Ex. I have this sequence file writeen as hadoop

Problem creating external table to a sequence file on HDFS

2013-04-08 Thread Ranjitha Chandrashekar
Hi I am trying to create a external table to a sequence file on HDFS. I have my own input format and a SerDe, which is compiled into a jar and added in HIVE. Inspite of doing this, I get the following error. Please Suggest. hive create table seq (key STRING, value STRING) ROW FORMAT SERDE

Error Creating External Table

2013-04-05 Thread Ranjitha Chandrashekar
Hi When i try creating a external table to a text file on HDFS i get the following error. Could someone please let me know where I am going wrong. hive create external table seq4 (item STRING) row format delimited fields terminated by '' STORED as TEXTFILE location

RE: External Table to Sequence File on HDFS

2013-04-05 Thread Ranjitha Chandrashekar
-sequencefiles-with-hive From: Ranjitha Chandrashekar ranjitha...@hcl.commailto:ranjitha...@hcl.com Reply-To: user@hive.apache.orgmailto:user@hive.apache.org user@hive.apache.orgmailto:user@hive.apache.org Date: Wednesday, April 3, 2013 10:43 PM To: user@hive.apache.orgmailto:user@hive.apache.org user

RE: Error Creating External Table

2013-04-05 Thread Ranjitha Chandrashekar
giving location give it as '/user/myfolder/items' hive know it is need to be store at HDFS which is define at $HADOOP_CONF_DIR/hdfs-site.xml. Thanks, ./Piyush From: Ranjitha Chandrashekar [ranjitha...@hcl.com] Sent: Friday, April 05, 2013 3:16 PM To: user

External Table to Sequence File on HDFS

2013-04-03 Thread Ranjitha Chandrashekar
Hi I want to create a external hive table to a sequence file(each record - key value) on HDFS. How will the field names be mapped to the column names. Please Suggest. Thanks Ranjitha. ::DISCLAIMER::

External hive table to a Sequence file

2013-04-01 Thread Ranjitha Chandrashekar
Hi I want to create a external hive table to a sequence file(each record - key value) on HDFS. How will the field names be mapped to the column names. Please Suggest. Thanks Ranjitha. ::DISCLAIMER::