Re: Configure hiveserver2 logs

2016-09-28 Thread Chetna C
Hi Kishore, Setting above 3 parameters enables query/operations logs. If you are looking for HiveServer2 process log, you'll need to configure it while launching HiveServer2 Process with following jvm params "-Dhive.log.dir= -Dhive.log.file=hive-server2.log" You can refer to "Hive Logging" se

Re: Small files under SequenceFile table partition directories

2015-11-11 Thread Chetna C
You can get rid of processing overhead by using splittable compression for your hive table data, something like 4mc . Or you can use hadoop's getmerge utility to merge small files periodically. Thanks, Chetna Chaudhari On 11 November 2015 at 10:56, reveen joe w

Re: exporting and importing a schema/database from Hive Test to Hive DEV

2015-11-11 Thread Chetna C
Hi Ashok, You can achieve this by either sharing same metastore between test and dev instance. With isolated access to databases , say test-user and dev-user, where dev-user can access all test databases.Or you can use Hive/LanguageManual+ImportExport

Re: How to set add jar jarpath within hive jdbc query?

2015-11-05 Thread Chetna C
You can move your auxiliary jars to some hdfs location. And use that path instead of local path. Thanks, Chetna Chaudhari On 5 November 2015 at 19:13, Suresh Kumar Sethuramaswamy wrote: > You can try adding it in hive/lib location on all the cluster nodes. You > dont need to add it part of your

Re: [ANNOUNCE] New Hive PMC Chair - Ashutosh Chauhan

2015-09-16 Thread Chetna C
Congrats Ashutosh ! Thanks, Chetna Chaudhari On 17 September 2015 at 06:53, Navis Ryu wrote: > Congratulations! > > 2015-09-17 9:35 GMT+09:00 Xu, Cheng A : > > Congratulations, Ashutosh! > > > > -Original Message- > > From: Mohammad Islam [mailto:misla...@yahoo.com.INVALID] > > Sent: Th

Re: Tables missing on the file system

2015-09-14 Thread Chetna C
Hi Ravi, Please make sure the location mentioned while create table exists at the time of *'MSCK REPAIR'*. This error occurs, if location does not exists on fs. Thanks, Chetna Chaudhari On 15 September 2015 at 12:03, ravi teja wrote: > Hi, > I am getting this exception when I repair a table