RE: Setting | Verifying | Hive Query Parameters from Java

: Setting | Verifying | Hive Query Parameters from Java Hi Rinku, I think yarn.nodemanager.resource.memory-mb is a static configuration prop. You can not change this dynamically. The other MR props looks OK to me. On Fri, Mar 7, 2014 at 2:58 PM, Garg, Rinku mailto:rinku.g...@fisglobal.com>> wro

RE: Setting | Verifying | Hive Query Parameters from Java

ps in your jdbc connetion with HQL like "propA=valueA;" More, your connection url is for hive server, it does not work for hive server2. If you need to use hive server2, you have to use jdbc:hive2://master149:1/default On Tue, Mar 4, 2014 at 7:43 PM, Garg, Rinku mailto:rinku.g..

RE: Setting | Verifying | Hive Query Parameters from Java

Hi All, Can anybody help me on below mail trail. Thanks Rinku Garg From: Garg, Rinku Sent: Tuesday, March 04, 2014 5:14 PM To: user@hive.apache.org Subject: Setting | Verifying | Hive Query Parameters from Java Hi All, We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as

Setting | Verifying | Hive Query Parameters from Java

Hi All, We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as desired. We need to set hive configuration parameter from Java while making JDBC connection. We have written a java program to execute queries on hive server with some configurations properties setting dynamicall

Hive .012 works with CDH 4.2.0

Hi All, We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as desired. Now we want to replace hive-0.10.0-cdh4.2.0 with apache hive 0.12. Will this combination works? Thanks & Regards, Rinku Garg - Global Commercial Services _ The information contained in this

RE: issue about hive command line

Set your hive home to $HIVE_HOME variable and execute the following command. $HIVE_HOME/bin/hive -e "DDL" Thanks & Regards, Rinku Garg - Global Commercial Services From: ch huang [mailto:justlo...@gmail.com] Sent: 02 December 2013 13:22 To: user@hive.apache.org Subject: issue about hive comman

Stopping hive metastore

Is there any way to stop hive metastore without killing PID. Thanks & Regards, Rinku Garg _ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, dist

Impala Query problem

Hi All, We have installed cludera hadoop-2.0.0-mr1-cdh4.2.0 with hive-0.10.0-cdh4.2.0. Both are working as desired. We can run any query on hive shell. We also installed cloudera impala 1.1 . Show tables query works on impala-shell, but select query on impala shell gives following error: ERROR

RE: Problem starting Hive

Hi, Try this also in hive-site javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver Driver class name for a JDBC metastore Thanks & Regards, Rinku Garg From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: 17 October 2013 18:53 To: 'user@hive.apache.org'; 'nimar...

RE: Problem starting Hive

Remove this file /tmp/hive/hive.log and try again using hdfs user. Thanks & Regards, Rinku Garg From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: 17 October 2013 19:09 To: Garg, Rinku Cc: user@hive.apache.org Subject: RE: Problem starting Hive Hi Rinku, I tried running hiv

RE: Problem starting Hive

Hi, Are you logged in using hive specific user or as root user. /tmp/hive/hive.log file may be created once root user and it can’t be updated by any other user so it says permission denied. Thanks & Regards, Rinku Garg From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: 17 Octo

RE: Can we reduce/fix number of mappers in Hive

early what you want achieve we will be able to help better. On Wed, Oct 9, 2013 at 6:09 PM, Rajesh Balamohan mailto:rajesh.balamo...@gmail.com>> wrote: Did you try adjusting fileinputformat. Min and max size parameters? On Oct 9, 2013 5:51 PM, "Garg, Rinku" mailto:rinku.g...@

Can we reduce/fix number of mappers in Hive

Hi All We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We have the following query: Is there any option in Hive where mappers can be reduced/fixed? For example if there are 8 mapping tasks defined in Hadoop configuration, then is it possible to use 4 hive setups that uses 2 mapp

RE: Issue while quering Hive

a normal table with TextInputFormat (the default) and load data in the new table and give it a try. On Mon, Sep 16, 2013 at 3:36 PM, Garg, Rinku mailto:rinku.g...@fisglobal.com>> wrote: Hi Nitin, Yes, I created the table with sequencefile. Thanks & Regards, Rinku Garg From: Ni

RE: Issue while quering Hive

hdfs://localhost:54310/user/hive/warehouse/cpj_tbl/cpj.csv.gz not a SequenceFile Did you create table with sequencefile ? On Mon, Sep 16, 2013 at 1:33 PM, Garg, Rinku mailto:rinku.g...@fisglobal.com>> wrote: Hi All, I have setup Hadoop, hive setup and trying to load gzip file in hado

Issue while quering Hive

Hi All, I have setup Hadoop, hive setup and trying to load gzip file in hadoop cluster. Files are loaded successfully and can be view on web UI. While executing Select query it gives me the below mentioned error. ERROR org.apache.hadoop.security.UserGroupInformation: PriviledgedActionException

RE: '\N' is displayed in case of null column values in exporting hive query results to CSV file

cated in last (in schema)? On Wed, May 2, 2012 at 10:44 AM, Garg, Rinku mailto:rinku.g...@fisglobal.com>> wrote: Hi All, We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also loaded a large number of CSV files into HDFS successfully. We can query through hive CLI. Now when we

'\N' is displayed in case of null column values in exporting hive query results to CSV file

Hi All, We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also loaded a large number of CSV files into HDFS successfully. We can query through hive CLI. Now when we execute any query on the hive command prompt, we are getting result back. While we did following steps to get back

RE: Any column search in HIVE

Sent: 30 April 2012 12:18 To: user@hive.apache.org Subject: Re: Any column search in HIVE you can write your query in a file then execute the query like hive -f hive.hql > some_output_file Thanks, Nitin On Mon, Apr 30, 2012 at 11:28 AM, Garg, Rinku mailto:rinku.g...@fisglobal.com>> wrot

RE: Any column search in HIVE

Hi All, We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also loaded a large number of CSV files into HDFS successfully. We can query through hive CLI. Now we want to store the hive query output result to an CSV file. Any help is appreciated. Thanks Rinku Garg _ The

Any column search in HIVE

Hi All, We did a successful setup of hadoop-0.20.203.0 and hive-0.7.1. We also loaded a large number of CSV files into HDFS successfully. We can query through hive CLI. Now we want to search for an keyword in any of the columns of a particular table. Any link/thread will be helpful. Thanks & R

RE: Hive | HBase Integration

ata dir in hdfs not in HBase. Regards Bejoy K S >From handheld, Please excuse typos. ____ From: "Garg, Rinku" mailto:rinku.g...@fisglobal.com>> Date: Wed, 29 Feb 2012 05:29:12 + To: user@hive.apache.orgmailto:user@hive.apache.org%3cu...@hive.apache

RE: Hive | HBase Integration

Hi , We tried the same also by issuing the below mentioned command but command does not executes completely and a new command line is shown with an asterisk (*), and table does not gets created. CREATE EXTERNAL TABLE hive_hbasetable_k(key int, value string) STORED BY 'org.apache.hadoop.hive.hb