Bug when adding multiple partitions

Hi everyone, Consider following DDL: CREATE TABLE partition_test (a INT) PARTITIONED BY (b INT); ALTER TABLE partition_test ADD PARTITION (b=1) location '/tmp/test1' PARTITION (b=2) location '/tmp/test2'; Now lets have a look what was created: DESCRIBE EXT

Hive cli Vs beeline cli

Hi pros, Based on your experience with beeline cli, could you please share your thoughts in advantages of using beeline cli over default hive cli? Please share if you find any useful link for this info. Thanks Pandeeswaran

Re: Does hiveserver2 support -e and -f options

HiveServer2 is a daemon running on background, so it logically do not support -e and -f parameter in the similar fashion as the utility "hive". However the beeline client that can be used for talking to HiveServer2 do support both of them. Jarcec On Tue, Aug 13, 2013 at 01:22:07AM +, Sanja

Re: Building Hadoop/Hive App

Hello Guillermo, Sure, you can use the Thrift API to connect to Hive https://cwiki.apache.org/Hive/hiveclient.html#HiveClient-Python cheers, esteban. -- Cloudera, Inc. On Wed, Aug 14, 2013 at 3:45 PM, Guillermo Alvarado < guillermoalvarad...@gmail.com> wrote: > Hi everybody, > > I want to

Re: Review Request (wikidoc): LZO Compression in Hive

Once again, I am down on my knees humbling calling upon the Hive Jedi Masters to please provide this paadwaan with cwiki update privileges May the Force be with u Thanks sanjay From: Sanjay Subramanian mailto:sanjay.subraman...@wizecommerce.com>> Reply-To: "user@hive.apache.org

Re: Hive and Lzo Compression

I am not sure if in this cade data is loaded OR partition added with location specified (to some location in HDFS) Yes u r stating the question correctly sanjay From: Nitin Pawar mailto:nitinpawar...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apa

Building Hadoop/Hive App

Hi everybody, I want to build an application with Hadoop. I want to know which is the best way to comunicate my GUI (Django based) with Hive. I have a CDH4 cluster running, I need to perform queries to hive then graph the response. I know there is a JDBC client and a python client but I need hav

Re: Hive and Lzo Compression

Please correct me if I understood the question correctly You created a table def without mentioning a stored as clause then you load data into table from a compressed a file then do a select query and it still works but how did it figured out which compression codec to use? Am I stating it correc

Re: Strange error in Hive - Insert INTO

Another reason I can think of is possibly some STRING column in your table has a "DELIMITER" character…Like once in production I had tab spaces in the string and my table was also defined using TAB as delimiter From: Stephen Sprague mailto:sprag...@gmail.com>> Reply-To: "user@hive.apache.org

Re: Hive and Lzo Compression

That is really interesting…let me try and think of a reason…meanwhile any other LZO Hive Samurais out there ? Please help with some guidance sanjay From: w00t w00t mailto:w00...@yahoo.de>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>>, w00t w00t ma

Re: Strange error in Hive - Insert INTO

Hi Jerome, That's a grandiose sql statement you got there! :)I find that if you break up those nested queries into simple CTAS (Create Table AS) statements and create a cascading effect of referring to the table in the previous step it makes debugging *so* much easier. In other SQL dialects li

Strange error in Hive - Insert INTO

Hi everybody, I faced a strange error in Hive today. I have launch a hive script to make some calculations, joins, union, etc... and then insert these results in over hive table. Everything is working fine (.hql is working, full ok, data are imported), but one field (CO_RGRP_PRODUITS) is very st

Re: Hive and Lzo Compression

Thanks for your reply. The interesting thing I experience is that the SELECT query still works - even when I do not specify the STORED AS clause... that puzzles me a bit. Von: Sanjay Subramanian An: "user@hive.apache.org" ; w00t w00t Gesendet: 3:44 Mittwo