Hive Alter

Hi Team, I am trying to write my query results to a file. hive -e "alter table {0}.{1} partition(year='{2}',month='{3}',day='{4}',hour='{5}') CONCATENATE > /tmp/srinivas/test.log;"'.format(row[0],row[1],row[2],row[3],row[4],row[5])

Re: tunning guide

Hi, Use some query optimization techniques for query fast execution. Use, Partitions, Bucketing or create table in ORC format Regards, Srinivas T *Thanks & Regards,* *Srinivas T* On Tue, Dec 1, 2015 at 1:46 PM, San Luo wrote: > Hi guys, > > My query runs slowly in hive,

Re: SemanticException Unable to fetch table t. null

Can you please check metastore log? *Thanks & Regards,* *Srinivas T* On Tue, Nov 3, 2015 at 4:40 PM, Rajkumar Singh wrote: > it seems that you are having a problem metastore. > > On Tue, Nov 3, 2015 at 1:46 PM, Mich Talebzadeh > wrote: > >> Hi, >>

Re: insert timestamp values in Hive

Hi, If you want those properties to executed, then you need to create table in ORC format and need to change some configuration on Hive-Site.xml Regards, Srinivas T *Thanks & Regards,* *Srinivas T* On Tue, Oct 27, 2015 at 12:05 PM, Lefty Leverenz wrote: > Oh, right

Getting error while performing Insert query

Hi, Have you created the hive metastore. Have you changed the hive-site.xml with new config parameters ? On Wednesday, September 9, 2015, Sateesh Karuturi < sateesh.karutu...@gmail.com > wrote: > hello..., > iam using hive 1.1 and

Re: Concurrency issue, Setting hive.txn.manager to org.apache.hadoop.hive.ql.lockmgr.DbTxnManager

hi Mich, Have you created the hive metastore? And can you please check the log for hivemetastore As i also faced this issue before. And let me know *Thanks Regards,* *Srinivas T* On Tue, Apr 7, 2015 at 9:13 AM, Eugene Koifman ekoif...@hortonworks.com wrote: can you check that the schema

Re: hive 1.1.0 Error while Metastore starting

i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tables. *Thanks Regards,* *Srinivas T* On Tue, Mar 10, 2015 at 12:55 PM, Amith sha amithsh...@gmail.com wrote: so can u suggest the solution Thanks Regards Amithsha On Tue, Mar 10, 2015 at 12:53 PM, Srinivas Thunga

Re: hive cli problem

Hi, I am also getting the same problem in Hive 1.1.0 As said by you, jline jar is not there in Hadoop. How to find where this jar located and will be removed. Mine is Inside hadoop i am having folders like client, client-0.20 and cloudera, lib *Thanks Regards,* *Srinivas T* On Mon, Mar

Re: Hive Transactions fail

Hi, After seeing your mail, i came to know that you are trying to update and delete operations on Hive 1.0. For doing the same, After extracting Hive version, you have to create Hive meta store

Re: FW: Hive error while starting up services using Ambari

Hi, Have you created the Hive Metastore? http://www.cloudera.com/content/cloudera/en/documentation/cdh5/v5-1-x/CDH5-Installation-Guide/cdh5ig_hive_metastore_configure.html and then try to start the server *Thanks Regards,* *Srinivas T* On Thu, Mar 5, 2015 at 2:57 PM, Pratik Gadiya

column selection for insert

Hi, I am using Hive 0.14 Can any one help me on to execute the below type query insert into table emp (eid,ename) select * from dept where emp.id = dept.id *Thanks Regards,* *Srinivas T*

Re: column selection for insert

) is not supported in 0.14. You have to insert into all the columns in the table and they have to match the order of items in the select or values clause. This will be supported in 1.2. Alan. Srinivas Thunga srinivas.thu...@gmail.com February 26, 2015 at 4:34 Hi, I am using Hive 0.14

Re: column selection for insert

Hi, Then is there any way to achieve this? *Thanks Regards,* *Srinivas T* On Fri, Feb 27, 2015 at 9:53 AM, Siddharth Tiwari siddharth.tiw...@live.com wrote: Not yet ! Sent from my iPhone On Feb 26, 2015, at 8:23 PM, Srinivas Thunga srinivas.thu...@gmail.com wrote: Hi, Thanks

Re: ERROR OutOfMemoryError: Java heap space

. But its throwing error for large data set Thanks Shweta Jadhav -Srinivas Thunga srinivas.thu...@gmail.com wrote: - To: user@hive.apache.org user@hive.apache.org From: Srinivas Thunga srinivas.thu...@gmail.com Date: 02/25/2015 03:45PM Subject: Re: ERROR OutOfMemoryError: Java heap space

Re: ERROR OutOfMemoryError: Java heap space

OutOfMemoryError: Java heap space I am running the query using spring batch framework. Thanks Shweta Jadhav -Srinivas Thunga srinivas.thu...@gmail.com wrote: - To: user@hive.apache.org user@hive.apache.org From: Srinivas Thunga srinivas.thu...@gmail.com Date: 02/25/2015 02:43PM Subject: Re

Re: ERROR OutOfMemoryError: Java heap space

* from table; thanks Shweta Jadhav -Srinivas Thunga srinivas.thu...@gmail.com wrote: - To: user@hive.apache.org user@hive.apache.org From: Srinivas Thunga srinivas.thu...@gmail.com Date: 02/25/2015 01:09PM Subject: Re: Hi, Can you place the query as well which you are trying

Re: ERROR OutOfMemoryError: Java heap space

metastore as postgres db. Query is working fine in beeline command line interface but giving Heap space error while executing using JDBC java client. Thanks Shweta Jadhav -Srinivas Thunga srinivas.thu...@gmail.com wrote: - To: user@hive.apache.org user@hive.apache.org From: Srinivas

Re: ERROR OutOfMemoryError: Java heap space

Is your problem solved? *Thanks Regards,* *Srinivas T* On Wed, Feb 25, 2015 at 4:17 PM, Srinivas Thunga srinivas.thu...@gmail.com wrote: Hi, You can set fetch size based certain datatype like blob, image, etc statement.setFetchSize(1000); Try this. *Thanks Regards,* *Srinivas T

Re:

Hi, Can you place the query as well which you are trying? *Thanks Regards,* *Srinivas T* On Wed, Feb 25, 2015 at 1:02 PM, Jadhav Shweta jadhav.shw...@tcs.com wrote: Hi I am trying to run hive query Its getting executed from beeline interface but its throwing

Re: fail to drop table after upgrade to hive 0.14.0

Apply new configuration properties for hive0.14 in hive-site.xml file then drop or delete table On Monday, February 23, 2015, Jie Zhang jiezh2...@gmail.com wrote: Hi, I have an application using hive, and just upgraded from 0.13.1 to 0.14.0. However, a bunch of unit testcases, which are

Re: fail to drop table after upgrade to hive 0.14.0

, Srinivas Thunga srinivas.thu...@gmail.com wrote: Apply new configuration properties for hive0.14 in hive-site.xml file then drop or delete table On Monday, February 23, 2015, Jie Zhang jiezh2...@gmail.com wrote: Hi, I have an application using hive, and just upgraded from 0.13.1 to 0.14.0

Re: fail to drop table after upgrade to hive 0.14.0

hive.compactor.worker.threads – 1 *Thanks Regards,* *Srinivas T* On Mon, Feb 23, 2015 at 9:31 PM, Jessica Zhang jiezh2...@gmail.com wrote: Thanks for the reply! Would you please elaborate which new properties for hive 0.14? Jessica On Feb 23, 2015, at 1:03 AM, Srinivas Thunga srinivas.thu...@gmail.com wrote

Hive source pointing to http rather than https using maven

Refereed from the below link https://cwiki.apache.org/confluence/display/Hive/HiveDeveloperFAQ#HiveDeveloperFAQ-HowdoIimportintoEclipse ? Generating tarball resulted in below error. #mvn clean package -DskipTests -Phadoop-1 -Pdist ERROR:: Failed to execute goal on project hive-shims-common: