Re: HIVE building on ARM

2020-03-12 Thread Chinna Rao Lalam
work, first step we use > one of the short-term plan to enable > Hive on ARM, and 2nd Step, we look for the long run to discuss with HBase > to find out a fesiable solution. > > BR, > > Zhenyu Zheng > > On Tue, Mar 10, 2020 at 9:29 PM Chinna Rao Lalam < > lalamch

HIVE building on ARM

2020-03-10 Thread Chinna Rao Lalam
need to upgrade to protobuf-3.7.1. HIVE-21939 <https://issues.apache.org/jira/browse/HIVE-21939> upgraded protobuf-2.5.0 to protobuf-3.7.1, It have mainly 2 failures. We are working on this. Thanks, Chinna Rao Lalam

Re: Is there any way to find Hive query to Datanucleus queries mapping

2020-02-11 Thread Chinna Rao Lalam
ve/ql/metadata/Hive.java#L5405 > > cheers, > Zoltan > > On 2/10/20 1:07 PM, Chinna Rao Lalam wrote: > > Hi All, > > > > Is there any way to find Hive query to Datanucleus queries mapping. > > > > "select * from table" this hive query will genera

Is there any way to find Hive query to Datanucleus queries mapping

2020-02-10 Thread Chinna Rao Lalam
Hi All, Is there any way to find Hive query to Datanucleus queries mapping. "select * from table" this hive query will generate multiple Datanucleus queries and execute on configured DB. In our DB some of the queries are running slow, So we want to see hivequery->datanucleus query mapping to

What is the release plan for Hive 4.0.0

2020-01-21 Thread Chinna Rao Lalam
Hi all. Do we have any timelines for Hive 4.0.0 release. Thanks, Chinna

Re: Welcome new Hive committer, Zhihai Xu

2017-05-05 Thread Chinna Rao Lalam
Congratulations Zhihai... On Fri, May 5, 2017 at 10:22 PM, Xuefu Zhang wrote: > Hi all, > > I'm very please to announce that Hive PMC has recently voted to offer > Zhihai a committership which he accepted. Please join me in congratulating > on this recognition and thanking him

Re: Create ORC Table on Tez Failed

2015-06-04 Thread Chinna Rao Lalam
Hi, If you are table name is orc_table in the exception i can see the table name as test Moving data to: hdfs://namenode:8020/apps/hive/warehouse/test Failed with exception Unable to rename:

Re: HiveMetaStoreClient error

2015-06-04 Thread Chinna Rao Lalam
What is the error, can you add here.. On Thu, Jun 4, 2015 at 3:51 PM, Ankita Jhar ankitajharut...@gmail.com wrote: Hi, I attempted to configure the remote metastore I hive which did not succeed , so I reverted hive-site.XML settings to the previous ones ...now whenever I make any new

Re: Hiveserver2 stops logging

2015-06-04 Thread Chinna Rao Lalam
Hi, What version you are using and what is the environment.. On Thu, Jun 4, 2015 at 2:35 PM, Palani, MuthuKumar A muthu.ku...@firstdata.com wrote: Hi Folks, We are experiencing an issue with Hive that we have not been able to solve for few weeks. Hiveserver2 stops logging with no

Re: create statement in hive 1.0.0.

2015-06-04 Thread Chinna Rao Lalam
Please check Hive Language Manual https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML Hope It Helps, Chinna On Thu, Jun 4, 2015 at 4:28 PM, Sateesh Karuturi sateesh.karutu...@gmail.com wrote: anyone help me please... how to write insert statement in hive 1.0.0? -- Hope

Re: Tables affected by a query

2015-06-02 Thread Chinna Rao Lalam
To get table access info, need to enable this hive.stats.collect.tablekeys property.. By default it is false.. Hope It Helps, Chinna On Tue, Jun 2, 2015 at 2:45 PM, Amitosh Anand, IDD M Tech, Computer Sci. Engg., IIT (BHU) Varanasi amitosh.anand.cs...@iitbhu.ac.in wrote: Hi, I have been

Re: Beeline connect to hiveserver2 didn't print log.

2015-05-26 Thread Chinna Rao Lalam
By default beeline logs will come to console with log level WARN only. If you need some changes update the beeline-log4j.properties. On Wed, May 27, 2015 at 8:58 AM, r7raul1...@163.com r7raul1...@163.com wrote: I use hive1.1.0 beeline remote connect to hiveserver2. When I submit query , only

Re: [ANNOUNCE] New Hive Committer - Mithun Radhakrishnan

2015-04-15 Thread Chinna Rao Lalam
Congrats Mithun! On Wed, Apr 15, 2015 at 11:34 AM, Mohammad Islam misla...@yahoo.com wrote: Congrats Mithun! --Mohammad On Tuesday, April 14, 2015 9:10 PM, Prasanth Jayachandran pjayachand...@hortonworks.com wrote: Congrats Mithun! Thanks Prasanth On Tue, Apr 14, 2015 at

Re: [ANNOUNCE] New Hive Committers - Jimmy Xiang, Matt McCline, and Sergio Pena

2015-03-23 Thread Chinna Rao Lalam
Congratulations to all... On Mon, Mar 23, 2015 at 11:38 PM, Carl Steinbach c...@apache.org wrote: The Apache Hive PMC has voted to make Jimmy Xiang, Matt McCline, and Sergio Pena committers on the Apache Hive Project. Please join me in congratulating Jimmy, Matt, and Sergio. Thanks. -

Re: Number of hive-server2 threads increments after jdbc connection

2014-04-29 Thread Chinna Rao Lalam
Hi, In your code if more connections and statements are created?. If so, closed those connections? After use close unused connections and statements. Hope It Helps, Chinna On Tue, Apr 29, 2014 at 3:47 PM, Dima Fadeyev dfade...@pragsis.com wrote: Hello everyone, When I run a jdbc

Re: [ANNOUNCE] New Hive Committers - Prasanth J and Vaibhav Gumashta

2014-04-24 Thread Chinna Rao Lalam
Congratulations to Prasanth and Vaibhav! On Fri, Apr 25, 2014 at 8:23 AM, Shengjun Xin s...@gopivotal.com wrote: Congratulations ~~ On Fri, Apr 25, 2014 at 10:33 AM, Carl Steinbach cwsteinb...@gmail.comwrote: + Prasanth's correct email address On Thu, Apr 24, 2014 at 7:31 PM, Xuefu

Re: All Hive JDBC Queries Fail with Same Error: “Caused by: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTa

2014-04-21 Thread Chinna Rao Lalam
Hi, Here the MR job is failed, Check why the MR job is failed (From the job logs) .. Hope It Helps, Chinna Rao Lalam On Fri, Apr 18, 2014 at 9:53 PM, Vince George (vincgeor) vincg...@cisco.com wrote: We have just configured a new Hive JDBC client with an upgraded support for per user

Re: Help - Hadoop jar null org.apache.hadoop.hive.ql.exec.ExecDriver

2014-04-21 Thread Chinna Rao Lalam
Hi, Check may be hive-exec.jar is corrupted. Hope It Helps, Chinna Rao Lalam On Sat, Apr 19, 2014 at 2:38 AM, Abhishek Girish agir...@ncsu.edu wrote: Hello, I am hitting an error while executing a Hive job inside MapReduce: *Code snippet:* HiveConf conf initialization code String

Re: FAILED: SemanticException [Error 10001]: Table not found answer

2014-04-01 Thread Chinna Rao Lalam
Hi, Can you add what is the causedby excetion...or full exception. On Tue, Apr 1, 2014 at 11:09 AM, Rishabh Bhardwaj rbnex...@yahoo.comwrote: Hi all, I created the database 'test1' and a table 'my1' Now with show tables in test1 , hive shell is showing my1 but when I am trying to do,

Re: pig,hive install over hadoop

2014-04-01 Thread Chinna Rao Lalam
Hi, You need to install hive completely because both are different processes(Installing hive is very simple and it require few configurations). Hive process to work, it required Hadoop processes. I think same with the pig also(I did't try)... Hope It Helps, Chinna.. On Tue, Apr 1, 2014 at

Re: optimize hive query for multitable join where one table is huge

2014-03-28 Thread Chinna Rao Lalam
Hi, In hive different types of joins are there like join, map join , bucket map join and etc. Please take a look of these it may help you to optimize your query https://cwiki.apache.org/confluence/display/Hive/LanguageManual+JoinOptimization

Re: How do I get the php client to run?

2014-03-28 Thread Chinna Rao Lalam
Hi, 1. Start Hiveserver 2. In php client code set THRIFT_ROOT to php lib of hive distribution (Ex: /home/install/apache-hive-0.14.0-SNAPSHOT-bin/lib/php) Hope It Helps, Chinna On Fri, Mar 28, 2014 at 12:14 AM, Jeremy jk...@kickbackpoints.com wrote: Or how do query hive from php? On

Re: Number of Mapper when reading from Cassandra

2014-03-28 Thread Chinna Rao Lalam
Hi, Number of mappers will depend on some factors like, 1.The number of mappers is defined based on our data size (By default set to one per HDFS block). 2.The number of mappers depends on amount of InputSplit generated by InputFormat#getInputSplits method. In particular FileInputSplit splits

Re: Buildfile: build.xml does not exist!

2014-03-25 Thread Chinna Rao Lalam
Hi, Hive is mavenized, so please follow this link to build https://cwiki.apache.org/confluence/display/Hive/HowToContribute#HowToContribute-MakingChanges Hope It Helps you, On Tue, Mar 25, 2014 at 9:12 PM, Nagarjuna Vissarapu nagarjuna.v...@gmail.com wrote: Hi, Can you please help

Re: How to add partition using hive by a specific date?

2014-03-11 Thread Chinna Rao Lalam
Hi, Any exceptions in the log file? Try this for loading into partions. In your scenario if it is possible with load query. LOAD DATA INPATH '/user/myname/kv2.txt' OVERWRITE INTO TABLE invites PARTITION (ds='2008-08-15'); Hope it helps, Chinna

RE: modify Hive history file location

2012-01-27 Thread Chinna Rao Lalam
Hi, Change the value of this property hive.querylog.location . By default value is /tmp/{user.name} Hope It Helps, Chinna Rao Lalam From: Black, Brent [brent.bl...@disney.com] Sent: Friday, January 27, 2012 7:40 AM To: 'user@hive.apache.org' Subject

RE: Hive startup issue

2011-11-29 Thread Chinna Rao Lalam
) and any modifications u have done for hadoop distribution... Hope it helps, Chinna Rao Lalam. From: ram prasad [rammca...@yahoo.co.in] Sent: Tuesday, November 29, 2011 4:40 PM To: Chinna Rao Lalam Subject: Hive startup issue Hi Chinna, Can u pls take a look

RE: Hive console startup issue

2011-11-28 Thread Chinna Rao Lalam
will be used. And send which version u r using.. Hope it helps, Chinna Rao Lalam From: ram prasad [rammca...@yahoo.co.in] Sent: Monday, November 28, 2011 6:12 PM To: Chinna Rao Lalam Subject: Hive console startup issue Hi , I m unable to start the hive console

RE: ClassNotFoundException every time we run any hive query

2011-11-27 Thread Chinna Rao Lalam
.. Hope it helps, Chinna Rao Lalam From: Ghousia [ghousia.ath...@gmail.com] Sent: Monday, November 28, 2011 1:14 PM To: user@hive.apache.org Subject: ClassNotFoundException every time we run any hive query Hi, We always get this exception for any hive query we

RE: Asynchronous query exection

2011-11-15 Thread Chinna Rao Lalam
independent tasks if this property is true it will execute the independent tasks parallely otherwise it will execute sequentially. ThanksRegards, Chinna Rao Lalam From: Ghousia [ghousia.ath...@gmail.com] Sent: Tuesday, November 15, 2011 6:12 PM To: user

Re: Accessing distributed cache in transform scripts

2011-10-19 Thread Chinna Rao Lalam 72745
Hi, Can u post some more details like for the list file what command u have used. - Original Message - From: Mohit Gupta success.mohit.gu...@gmail.com Date: Wednesday, October 19, 2011 3:16 pm Subject: Re: Accessing distributed cache in transform scripts To: user@hive.apache.org

Re: When trying to create table Iam getting exception

2011-10-19 Thread Chinna Rao Lalam 72745
Hi, Check where u have configured some value to the hive.metastore.uris property in hive-default.xml or hive-site.xml and whether it is valid or not Hope it helps Chinna Rao Lalam - Original Message - From: kiranprasad kiranprasa...@imimobile.com Date: Wednesday, October 19, 2011 3

Re: comliler generated M-R tasks

2011-10-13 Thread Chinna Rao Lalam 72745
Hi, Check the org.apache.hadoop.hive.ql.exec.Operator and sub classes of the operator java code Hope it helps, Chinna Rao Lalam - Original Message - From: Yakubovich, Alexey alexey.yakubov...@navteq.com Date: Thursday, October 13, 2011 2:38 am Subject: comliler generated M-R tasks

Re: HiveDerbyServerMode

2011-10-10 Thread Chinna Rao Lalam 72745
it helps, Chinna Rao Lalam - Original Message - From: Matt Kennedy stinkym...@gmail.com Date: Monday, October 10, 2011 9:48 pm Subject: HiveDerbyServerMode To: user@hive.apache.org I'd like to set up the Hive metastore such that I'm running hive --service hiveserver which itself would

Re: Command works inside hive but not outside

2011-09-28 Thread Chinna Rao Lalam 72745
Hi Mark, I think 'apache_logs' table created from hive shell and select command is executed from 'hive -e'(outside) so the hive shell process is different and 'hive -e' process is different if derby started in embeded mode(hive by default provided embeded derby) it can't see the tables of

Re: Hive Custom UDF - hive.aux.jars.path not working

2011-08-23 Thread Chinna Rao Lalam 72745
Hi Amit, Pls check this issue HIVE-1405 it will help u .This issue targeting same scenario. Thanks Chinna Rao Lalam Hi Chinna, That worked, Thanks a lot. So once the jar is picked up, is there a way to create a temporary function, that is retained even if i quit the interactive