Re: In Beeline what is the syntax for ALTER TABLE ?

2013-10-21 Thread Sanjay Subramanian
Then something s broken in this version Thanks Regards sanjay From: Thejas Nair mailto:the...@hortonworks.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Monday, October 21, 2013 5:59 PM To: "mailto:user@hive.apache.org>>" mailto:user@hiv

Re: ArrayIndexOutOfBoundsException while writing MapReduce output as RCFile

2013-10-21 Thread Yin Huai
Seems you did not set the number of columns (RCFileOutputFormat.setColumnNumber(Configuration conf, int columnNum)). Can you set it in your main method and see if your MR program works? Thanks, Yin On Mon, Oct 21, 2013 at 2:38 PM, Krishnan K wrote: > Hi All, > > I have a scenario where I've t

Re: In Beeline what is the syntax for ALTER TABLE ?

2013-10-21 Thread Thejas Nair
beeline does not have any query syntax of its own, it just sends the query to hive server2, which uses same code as hive-cli to run the query. ie query syntax is same as hive cli On Mon, Oct 21, 2013 at 11:41 AM, Sanjay Subramanian < sanjay.subraman...@wizecommerce.com> wrote: > Hi guys > >

Re: HS2 ODBC incompatibility

2013-10-21 Thread Carl Steinbach
Cloudera has an ODBC driver that is compatible with both HiveServer1 and HiveServer2. More info here: http://www.cloudera.com/content/cloudera-content/cloudera-docs/Connectors/PDF/Cloudera-ODBC-Driver-for-Apache-Hive-Install-Guide.pdf Thanks. Carl On Mon, Oct 21, 2013 at 12:01 PM, Thejas Nair

Re: HS2 ODBC incompatibility

2013-10-21 Thread Thejas Nair
Yes, the current odbc driver source in hive is not compatible with hive server2. I am not aware of any body working on it. But you can download odbc driver add on for hive server2, for free from the hortonworks website - http://hortonworks.com/download/download-archives/ On Mon, Oct 21, 2013 at 5:

In Beeline what is the syntax for ALTER TABLE ?

2013-10-21 Thread Sanjay Subramanian
Hi guys Using Hive0.10.0+198 CDH4 Getting this error for ALTER table command jdbc:hive2://dev-thdp5.corp.nextag.com:100> ALTER TABLE outpdir_seller_hidden ADD IF NOT EXISTS PARTITION (header_date_partition='2013-10-17', header_servername_partition='lu3') LOCATION '/data/output/impres

ArrayIndexOutOfBoundsException while writing MapReduce output as RCFile

2013-10-21 Thread Krishnan K
Hi All, I have a scenario where I've to read an RCFile, process it and write the output as an RCFile using a MapReduce program. My Hadoop version is *CDH 4.2.1 * * * *Mapper* Map Input = LongWritable, BytesRefArrayWritable Map Output = Text, BytesRefArrayWritable (Record)

Re: hive_service.thrift vs TCLIService.thrift

2013-10-21 Thread Vaibhav Gumashta
Hi Haroon, hive_service.thrift is the interface definition language (IDL) file for HiveServer (older one), whereas TCLIService.thrift is the IDL for HiveServer2. HiveServer2 was introduced in Hive-0.11. Check the docs here: https://cwiki.apache.org/confluence/display/Hive/Setting+up+HiveServer2

hive_service.thrift vs TCLIService.thrift

2013-10-21 Thread Haroon Muhammad
Hi, Can anyone share what's the difference between hive_service.thrift and TCLIService.thrift? Thanks,

HS2 ODBC incompatibility

2013-10-21 Thread Haroon Muhammad
Hi, Source under ODBC seems to be incompatible with HS2's changed RPC thrift interface. Are there any plans on getting an updated version out any time sooner ? Thanks,

Re: ClassCastExceptions using Hiveserver2 Thrift interface, Hive 0.11

2013-10-21 Thread Andy Sykes
I can report I see this same error when working with the Perl thrift Hive client ( http://search.cpan.org/~dmor/Thrift-API-HiveClient2-0.011/lib/Thrift/API/HiveClient2.pm), and with the newly released Hive 0.12.0. Is anyone successfully using Hiveserver2, or do I have something odd in my environme