Re: Hive TTransportException - Create Table

2016-04-28 Thread Vineet Mishra
ich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On

Hive TTransportException - Create Table

2016-04-27 Thread Vineet Mishra
Hi All, I am running Hive Server2 on a big Hadoop cluster space and things looks good, I have a custom code which takes care of running some queries on top of Hive and processing the resultant accordingly. The Queries are dependent on certain table which are created on Runtime(refreshed every hou

Re: Re: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
need full > access to the hive warehouse directory. Is the table managed by hive? > On Oct 20, 2015 6:54 PM, "Vineet Mishra" wrote: > >> Hi, >> >> I already stated my requirement since the files are generating on hdfs >> and i want to load the file from hdfs to

Re: Re: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
e file on the hiveserver2 host local filesystem . Then try > load data local inpath > > -- > r7raul1...@163.com > > > *From:* Vineet Mishra > *Date:* 2015-10-21 03:05 > *To:* user > *CC:* cdh-user > *Subject:* Re: HiveServer2 load dat

Re: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
ldn't get any possible solution for this. Does it mean HS2 is incapable of supporting load data or there's no JIRA open for it? Version : 0.13.1-cdh5.3.2 On Tue, Oct 20, 2015 at 10:54 PM, Vineet Mishra wrote: > My data files resides on hdfs and for the given command I guess it will &

RE: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
My data files resides on hdfs and for the given command I guess it will point to local filesystem instead of hdfs. On Oct 20, 2015 10:25 PM, "Vikas Srivastava" wrote: > You Need to use “load data local inpath” > > > > > > *From:* Vineet Mishra [mailto:clearmido.

HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
Hi All, I am trying to run load data inpath to update/refresh my table data in hive. I am using HiveServer2 to make jdbc connection and run the following command load data inpath 'path_to_file_on_hdfs' overwrite into table tablename; Eventually this query works fine with HiveServer1 through thri

Re: HiveServer2 Goes down while parallel Query execution

2015-10-11 Thread Vineet Mishra
;> So we run multiple copies of hsw with load balancer in front and do >>> application retries to deal qith hs2. This is a lot of engineering for >>> somethinf rhat does 8 queries an hour. >>> >>> If i could start over again i would just have our app create a

Re: HiveServer2 Goes down while parallel Query execution

2015-10-10 Thread Vineet Mishra
in a row to see how unrelable it is. Your never going to get anyone on >>> this list to admit to any problems either... >>> >>> On Sat, Oct 10, 2015 at 11:42 AM, Vineet Mishra >>> wrote: >>> >>>> Any update on this? >>>> >>&

Re: HiveServer2 Goes down while parallel Query execution

2015-10-10 Thread Vineet Mishra
Any update on this? URGENT CALL! On Oct 10, 2015 9:25 AM, "Vineet Mishra" wrote: > Hi Jimmy, > > Any prominent reason for it run out of worker thread when maximum query > fired at a time fired are only 8. > > I am trying to open multiple session on different

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
uld it be because HS2 runs out of worker threads? > Are you trying to open multiple sessions on the same connection? > > Thanks, > Jimmy > > On Fri, Oct 9, 2015 at 12:34 PM, Vineet Mishra > wrote: > >> Any idea about this? >> >> Frequent Connectivity issue t

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
:11,071 [main] ERROR (HiveRunnable.java:48) - Could not establish connection to jdbc:hive2://hadoop-hs2:1/mydb: null URGENT CALL! Thanks! On Fri, Oct 9, 2015 at 2:42 PM, Vineet Mishra wrote: > This looks out to be the issue > > https://issues.apache.org/jira/browse/HIVE-2314 > > An

Re: HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
This looks out to be the issue https://issues.apache.org/jira/browse/HIVE-2314 Any workaround or resolution to the same. Thanks! On Fri, Oct 9, 2015 at 1:24 PM, Vineet Mishra wrote: > Hi All, > > I am trying to connect to HiveServer2 to query some data in parallel and > landing

Re: Hive Server gets stucked with Load Data InPath

2015-10-09 Thread Vineet Mishra
Any update around this? Thanks! On Fri, Oct 2, 2015 at 7:44 PM, Vineet Mishra wrote: > Hi Praveen, > > This is the complete exception stack I m having. > > Thanks! > On Oct 1, 2015 7:37 PM, "praveen singh" > wrote: > >> Plz send attachment >>

HiveServer2 Goes down while parallel Query execution

2015-10-09 Thread Vineet Mishra
Hi All, I am trying to connect to HiveServer2 to query some data in parallel and landing up into some weird exception, stack trace mentioned below java.sql.SQLException: Error while cleaning up the server resources at org.apache.hive.jdbc.HiveConnection.close(HiveConnection.java:569) at com.sd.dw

Re: Hive Server gets stucked with Load Data InPath

2015-10-01 Thread Vineet Mishra
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) This is the issue observed after the HiverServer is running for a a week or more than that. Thanks! On Sun, Sep 27, 2015 at 1:35 PM, Vineet Mishra wrote: > Hi All, > > I am using H

Hive Server gets stucked with Load Data InPath

2015-09-27 Thread Vineet Mishra
Hi All, I am using HiveServer for loading some tables using "Load Data InPath" but not sure why for some tables the call gets stucked. I am using the call in Java Threaded Environment to ensure table load/refresh in prolong period of time, which is around some buffer time. For the first time it w

Re: Hive Server Load Data InPath Fails

2015-09-12 Thread Vineet Mishra
ied database. > > On Fri, Sep 11, 2015 at 12:44 AM, Vineet Mishra > wrote: > >> >> Hi All, >> >> I am making a Hive Thrift connection to Hive Server and with load data >> inpath command to one of my table I am landing into some bizzare exception. >> >>

Fwd: Hive Server Load Data InPath Fails

2015-09-11 Thread Vineet Mishra
Hi All, I am making a Hive Thrift connection to Hive Server and with load data inpath command to one of my table I am landing into some bizzare exception. Other queries seems out to be working fine, but this is the only query which is getting failed 15/09/11 11:40:32 ERROR utils.HCatalogUtil: Ex