Re: Impala Query problem

2013-10-22 Thread Bertrand Dechoux
It might be best to use the forum for Impala. I am not sure what replies your are expecting from the hive and hbase mailing lists. https://groups.google.com/a/cloudera.org/forum/#!forum/impala-user Regard Bertrand On Tue, Oct 22, 2013 at 10:13 AM, Garg, Rinku rinku.g...@fisglobal.comwrote:

Re: Export to RDBMS directly

2013-07-17 Thread Bertrand Dechoux
virus or disabling code in this e-mail -- Bertrand Dechoux

Re: How Can I store the Hive query result in one file ?

2013-07-04 Thread Bertrand Dechoux
DIRECTORY '/directory_path_name/')? Thanks for your answers -- Nitin Pawar -- Bertrand Dechoux

Re: Run queries from external files as subqueries

2013-06-20 Thread Bertrand Dechoux
and instruct the enclosing query to execute these files. This way these subqueries can potentially be reused by other questions or just run by themselves. Thanks, Sha Liu -- Bertrand Dechoux

Re: Real-life experience of forcing smaller input splits?

2013-01-25 Thread Bertrand Dechoux
to avoid if at all possible. All the hive settings that we tried only got me as far as raising the number of mappers from 5 to 6 (yay!) where I would have needed at least ten times more. Thanks! D.Morel -- Nitin Pawar -- Bertrand Dechoux

Re: Java run

2012-11-24 Thread Bertrand Dechoux
at 10:20 PM, Dalia Sobhy dalia.mohso...@hotmail.comwrote: Dear all, I want to run java code on top of hadoop on ubuntu server , do anyone know the commands?? -- Bertrand Dechoux

Re: How to run multiple Hive queries in parallel

2012-10-22 Thread Bertrand Dechoux
in interactive mode. Thank You, Chunky. -- Bertrand Dechoux

Re: Embedded mode for jdbc client inside a multi-threaded (web) application

2012-10-01 Thread Bertrand Dechoux
: The data store does is not embedded. I have described how I accessed hive from jython at http://csgrad.blogspot.in/2010/04/to-use-language-other-than-java-say.html. The example there may be relevant for your use case. Dilip On Sun, Sep 30, 2012 at 8:05 AM, Bertrand Dechoux decho

Embedded mode for jdbc client inside a multi-threaded (web) application

2012-09-30 Thread Bertrand Dechoux
standalone server? Regards Bertrand Dechoux

Re: Error on hive web interface

2012-09-29 Thread Bertrand Dechoux
, Bertrand Dechoux a écrit : I am not a Jetty expert but it could be that the war is somehow corrupted/damaged. Jar/War are plain zip archives but with specific files and a different file extension. Can you open it? I don't think there is a hash of it available but there should be for the full hive

Re: Error on hive web interface

2012-09-28 Thread Bertrand Dechoux
where does it come from? and how to fix it? Thanks for your help, Regards, Germain Tanguy. -- Bertrand Dechoux

Re: Reduce phase initialization

2012-09-27 Thread Bertrand Dechoux
be the reason for this. Regards Abhi Sent from my iPhone -- Bertrand Dechoux

Re: issue hive with external derby

2012-09-26 Thread Bertrand Dechoux
valueorg.apache.derby.jdbc.ClientDriver/value descriptionDriver class name for a JDBC metastore/description /property 2) I tried hadoop-0.22.0 with hive-0.8.0. It is always throwing shims issue... Can you please tell me how to overcome this? Thanks, B Anil Kumar. -- Bertrand

Re: Custom MR scripts using java in Hive

2012-09-25 Thread Bertrand Dechoux
Thanks for ur help in advance :) Thanks Regards, Manu ** ** ** ** -- *Thanks Regards,* *Tamil* -- Bertrand Dechoux

Re: How connect to hive server without using jdbc

2012-09-25 Thread Bertrand Dechoux
-- _ Dilip Antony Joseph http://csgrad.blogspot.com http://www.marydilip.info -- Bertrand Dechoux

Re: ERROR :regarding Hive WI, hwi service is not running

2012-09-19 Thread Bertrand Dechoux
javaewah-0.3.jar -rw-rw-r-- 1 root root 198552 Dec 24 2009 jdo2-api-2.3-ec.jar Please suggest regarding Thanks regards Yogesh Kumar -- Swarnim -- Swarnim -- Bertrand Dechoux

Re: How to get percentage of each group?

2012-09-06 Thread Bertrand Dechoux
, but not hive. select userType , count(1)/(select count(1) from some_table) from some_table group by userType -- Bertrand Dechoux

Re: Improving query performance on hive and hdfs

2012-09-05 Thread Bertrand Dechoux
on top of 90 million records that took 12 minutes to execute and same query on sql server took 8 minutes.My question is how can i make hadoop's performance better.What all configurations will improve the latency? Thanks Regards Prabhjot -- Bertrand Dechoux

Re: New Learner for Haddop and Hive

2012-09-05 Thread Bertrand Dechoux
. Before opening any email and/or attachments, please check them for viruses and other defects. -- Bertrand Dechoux

Re: Java methods from within a Hive query

2012-09-04 Thread Bertrand Dechoux
hive.Now looking for Java methods from within a Hive query.Is UDF the only option to achieve it.if any other option is available then please guide me with links or examples. Thanks Regards, Tamil -- Bertrand Dechoux

HiveServer can not handle concurrent requests from more than one client?

2012-08-27 Thread Bertrand Dechoux
Hi, I would like to have more information about this specific sentence from the documentation. HiveServer can not handle concurrent requests from more than one client. https://cwiki.apache.org/Hive/hiveserver.html Does it mean it is not possible with this server to provide a JDBC access to an

Re: HiveServer can not handle concurrent requests from more than one client?

2012-08-27 Thread Bertrand Dechoux
-- Bertrand Dechoux

Re: Long running Join Query - Reduce task fails due to failing to report status

2012-08-24 Thread Bertrand Dechoux
radio callsign: NW0W -- Bertrand Dechoux

Re: NOT IN clause in Hive

2012-08-14 Thread Bertrand Dechoux
or any attachment and you are advised to use up-to-date virus checking software. -- Bertrand Dechoux

Re: OPTIMIZING A HIVE QUERY

2012-08-14 Thread Bertrand Dechoux
sudeeptok...@gmail.comwrote: Hi all, How to avoid serialization and deserialization overhead in hive join query ? will this optimize my query performance. Regards sudeep -- Bertrand Dechoux

Re: Nested Select Statements

2012-08-09 Thread Bertrand Dechoux
. What is wrong with the above queries? 2. Is there another way to find number of rows in a table? 3. Is there a better way for what I am trying to do? ** ** Thanks, Richin -- Bertrand Dechoux

Re: Nested Select Statements

2012-08-09 Thread Bertrand Dechoux
, richin.j...@nokia.com wrote: Thanks Guys, it worked. ** ** *From:* ext Bertrand Dechoux [mailto:decho...@gmail.com] *Sent:* Thursday, August 09, 2012 5:03 PM *To:* user@hive.apache.org *Subject:* Re: Nested Select Statements ** ** Basically a cross join. You would have the same

Re: mapper is slower than hive' mapper

2012-08-06 Thread Bertrand Dechoux
of mapreduce to do the job. I just try the buffer in mapper approach, the number of map output record matches with Hive. Thank you On 08/01/2012 11:40 AM, Bertrand Dechoux wrote: I am not sure about Hive but if you look at Cascading they use a pseudo combiner instead of the standard (I mean

Re: mapper is slower than hive' mapper

2012-08-01 Thread Bertrand Dechoux
. Is there any trick in hive to speed this thing up? Thank you! Best, -- Bertrand Dechoux

Re: mapper is slower than hive' mapper

2012-08-01 Thread Bertrand Dechoux
(Double.parseDouble(sLine[2]))); } } I assume hive is doing something similar. Is there any trick in hive to speed this thing up? Thank you! Best, -- Bertrand Dechoux

Re: mapper is slower than hive' mapper

2012-08-01 Thread Bertrand Dechoux
side aggregation. Hive does use writables, sometimes it uses ones from hadoop, sometimes it uses its own custom writables for things like timestamps. On Wed, Aug 1, 2012 at 11:40 AM, Bertrand Dechoux decho...@gmail.com wrote: I am not sure about Hive but if you look at Cascading they use

Re: Can't use OR in left join

2012-07-26 Thread Bertrand Dechoux
26, 2012 at 11:19 PM, Bertrand Dechoux decho...@gmail.comwrote: That's a problem which is hadoop related and not really hive related. The solution is to use only equal (as you know it). For that, you should first extract your real identifier for a, which can be a.pid or a part of it. I assume

Re: Continuous log analysis requires 'dynamic' partitions, is that possible?

2012-07-25 Thread Bertrand Dechoux
: Continuous log analysis requires 'dynamic' partitions, is that possible? If you are using Amazon (AWS), you can use ‘recover partitions’ to enable all top level partitions. This will add required dynamicity. Regards, Puneet Khatod From: Bertrand Dechoux [mailto:decho

Re: Continuous log analysis requires 'dynamic' partitions, is that possible?

2012-07-25 Thread Bertrand Dechoux
, 2012 at 10:51 AM, Bertrand Dechoux decho...@gmail.comwrote: @Puneet Khatod : I found that out. And that's why I am asking here. I guess non AWS users might have the same problems and a way to solve it. @Ruslan Al-fakikh : It seems great. Is there any documentation for msck? I will find out

Re: Loading data into data_dim table

2012-07-25 Thread Bertrand Dechoux
NULLNULLNULL Please help me on this issue, I have missed anything wrong? Thanks, Prabhu. -- Bertrand Dechoux

Challenging priority : HIVE-2910 Improve the HWI interface

2012-07-25 Thread Bertrand Dechoux
Hi, Here is my stand. Hive provides a dsl to easily explore data contained in hadoop with limited experience with java and MapReduce. And Hive Web Interface provides an easy exposition : users need only a browser and the hadoop cluster can be well 'fire-walled' because the communication is only

Re: Challenging priority : HIVE-2910 Improve the HWI interface

2012-07-25 Thread Bertrand Dechoux
, Jul 25, 2012 at 11:25 AM, Bertrand Dechoux decho...@gmail.com wrote: Hi, Here is my stand. Hive provides a dsl to easily explore data contained in hadoop with limited experience with java and MapReduce. And Hive Web Interface provides an easy exposition : users need only a browser

Re: Challenging priority : HIVE-2910 Improve the HWI interface

2012-07-25 Thread Bertrand Dechoux
, Bertrand Dechoux decho...@gmail.comwrote: Great answer. Thanks a lot. 1) I understand the concern with branches but I quickly reviewed the change for 0.9.1 and not everything seemed to be a bug patch. So I thought : why not ask about HIVE-2910. 2) I wasn't sure about that, it seems logical though

Continuous log analysis requires 'dynamic' partitions, is that possible?

2012-07-24 Thread Bertrand Dechoux
clean way to do it? Regards, Bertrand Dechoux