RE: Error - loading data into tables

Thanks Pawar. Thanks,Manickam P Date: Tue, 1 Oct 2013 13:18:24 +0530 Subject: Re: Error - loading data into tables From: nitinpawar...@gmail.com To: manicka...@outlook.com; d...@hive.apache.org CC: user@hive.apache.org Manickam, I am really not sure if hive supports Federated namespaces yet. I

RE: Error - loading data into tables

ry running this load data local inpath '/home/storage/mount1/tabled.txt' INTO TABLE TEST;" On Mon, Sep 30, 2013 at 7:13 PM, Manickam P wrote: Hi, I'm getting the below error while loading the data into hive table. return code 1 from org.apache.hadoop.hive.ql.exec.MoveT

Error - loading data into tables

Hi, I'm getting the below error while loading the data into hive table. return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask I used " LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO TABLE TEST;" this query to insert into table. Thanks, Manickam P

RE: unable to create a table in hive

Thanks man. I added hive site and it worked. Thanks, Manickam P From: Nitin Pawar<mailto:nitinpawar...@gmail.com> Sent: ‎30-‎09-‎2013 05:35 PM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: Re: unable to create a table in hive hive-s

RE: unable to create a table in hive

Hi, I have given below the script i used. I've not used any hive site xml here. CREATE TABLE TABLE_A (EMPLOYEE_ID INT, EMPLOYEE_NAME STRING, EMPLOYEE_LOCATION STRING, EMPLOYEE_DEPT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE; Thanks, Manickam P Da

unable to create a table in hive

hdfs like /home/storate/tmp and /home/storage/user/hive/warehouse and given permission but it is not taking up. I'm having hdfs federated cluster with 2 name nodes. does anyone have any idea? Thanks, Manickam P

Hive Query - Issue

Hello Experts, when i try to execute the below query i'm getting error. Please help me to correct this. insert overwrite table table_baseline partition (sourcedate='base_2013_08') select * from (select * from table_a where sourcedate='tablea_2013_08' union all select * from table_b where sou

RE: Hive Query Issue

also. All my data nodes are up and running. I don't have any clue here. Thanks, Manickam P Date: Tue, 6 Aug 2013 16:24:38 +0530 Subject: Re: Hive Query Issue From: nitinpawar...@gmail.com To: user@hive.apache.org when you run select * from table .. it does not launch a mapreduce job, wher

Hive Query Issue

peratorIt just prints the above after that nothing happening in the hive shell. Can you pls help me on this. Thanks, Manickam P

Hive - Alter column datatype

Hi experts, I have created a table in hive and loaded the data into it. now i want to change the datatype of one particular column. Do i need to drop and move the file again to hive?will it work fine if i just alter the data type alone in hive? Thanks,Manickam P

RE: Hive Query

, Manickam P Date: Fri, 12 Jul 2013 17:00:38 +0530 Subject: Re: Hive Query From: nitinpawar...@gmail.com To: user@hive.apache.org Manickam, How does support the in clause what hive does not support is "subquery inside in clause" you can perfectly run the query you have written but currently

Hive Query

Hi, I need to run hive query like select * from employee where employee_id IN (100,102). I came to know that hive does not support IN clause.Then what is the effective replacement for this? i need to execute around 250 inputs. I'm using hive 0.9.0 version. Please guide me. Thanks, Manickam P

Hive Storage

Hi experts, In hive While we load files into tables will it be stored in master node only? or will it use data nodes also for HDFS storage? Please clarify. Thanks, Manickam P

Hive - UDF

Hi, Can we write more than one function like to_upper and to_lower in same UDF ? Or do we need write separate UDF for each? Please let me know. Thanks, Manickam P

Moving hive from one server to another

mistake here. I don't have any clue. Thanks, Manickam P

RE: Unable to execute a query in hive

27, 2013 at 11:17 PM, Manickam P wrote: Hi, I checked all the nodes. All are up and running. normal hive queries like show tables are working fine. Queries with map reduce is throwing exception. Thanks, Manickam P From: donta...@gmail.com Date: Thu, 27 Jun 2013 21:59:22 +0530 Subject

RE: Unable to execute a query in hive

Hi, I checked all the nodes. All are up and running. normal hive queries like show tables are working fine. Queries with map reduce is throwing exception. Thanks, Manickam P From: donta...@gmail.com Date: Thu, 27 Jun 2013 21:59:22 +0530 Subject: Re: Unable to execute a query in hive To: user

Unable to execute a query in hive

pl.java:43) at java.lang.reflect.Method.invoke(Method.java:616)at org.apache.hadoop.util.RunJar.main(RunJar.java:156)FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask Thanks, Manickam P