AW: Hive skipping first line

2013-05-23 Thread Tim Bittersohl
Can u try doing a Hive -e "select * from tablename" See how many rows this gets u Thanks sanjay From: Tim Bittersohl Reply-To: "user@hive.apache.org" Date: Wednesday, May 22, 2013 9:57 AM To: "user@hive.apache.org" Subject: Hive skipping first li

Hive skipping first line

2013-05-22 Thread Tim Bittersohl
4.2.0) with the "hiveClient.fetchN(rowncount)" command, it seems like he always skip the first line of data. (perhaps he's expecting a header row?) How can I avoid this? Greetings, Tim Bittersohl

AW: Hive query problem on S3 table

2013-04-19 Thread Tim Bittersohl
] Gesendet: Donnerstag, 18. April 2013 17:32 An: user@hive.apache.org Betreff: Re: Hive query problem on S3 table Tim, Could you try doing set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; before running the query? Shrikanth On Apr 18, 2013, at 8:09 AM, Tim Bittersohl

AW: Hive query problem on S3 table

2013-04-18 Thread Tim Bittersohl
; before running the query? Shrikanth On Apr 18, 2013, at 8:09 AM, Tim Bittersohl wrote: Thanks for your answer, I tested the program with an S3N setup and unfortunately got the same error behavior... Von: Dean Wampler [mailto:deanwamp...@gmail.com] Gesendet: Donnerstag, 18. April

AW: Hive query problem on S3 table

2013-04-18 Thread Tim Bittersohl
sure what's happening here, but one suggestion; use s3n://... instead of s3://... The "new" version is supposed to provide better performance. dean On Thu, Apr 18, 2013 at 8:43 AM, Tim Bittersohl wrote: Hi, I just found out, that I don't have to change the defa

AW: Hive query problem on S3 table

2013-04-18 Thread Tim Bittersohl
] Gesendet: Donnerstag, 18. April 2013 16:18 An: user@hive.apache.org Betreff: Re: Hive query problem on S3 table This means.. it is still not looking in S3... On Apr 18, 2013 3:44 PM, "Tim Bittersohl" wrote: Hi, I just found out, that I don't have to change the default

Using data from S3 on local cluster

2013-04-18 Thread Tim Bittersohl
Hi, I do have an urgent problem with the Hive server in Java, reading data from Amazon S3. I try to read data from a table which content is stored on Amazon S3 space and process it with a local cluster. This data is accessed setting the following value of the configuration of the server

AW: Get the job id for a hive query

2013-03-05 Thread Tim Bittersohl
4:58 PM, Tim Bittersohl wrote: Hi, I do have the following problem monitoring my Hive queries in Hadoop. I create a Sever using the Hive library which connects to an Hadoop cluster (file system, job tracker and Hive metastore are set up on this cluster). The needed parameters for the Hive

AW: Get the job id for a hive query

2013-03-05 Thread Tim Bittersohl
t this property mapred.job.name and this should set the name for the job On Thu, Feb 28, 2013 at 8:26 PM, Tim Bittersohl wrote: Thanks for the response, I also found no way to access the job id via java thrift client, all I can get is a query ID by the query planner. How to set the name of a j

AW: Get the job id for a hive query

2013-02-28 Thread Tim Bittersohl
Thanks for the response, I also found no way to access the job id via java thrift client, all I can get is a query ID by the query planner. How to set the name of a job where a Hive query is fired with, so I can find it in the job tracker later? Tim Bittersohl Software Engineer

AW: Get the job id for a hive query

2013-02-28 Thread Tim Bittersohl
I use java and there HiveClient of the hive library (Version 0.10.0). Tim Bittersohl Software Engineer http://www.innoplexia.de/ci/logo/inno_logo_links%20200x80.png Innoplexia GmbH Mannheimer Str. 175 69123 Heidelberg Tel.: +49 (0) 6221 7198033 Fax: +49 (0) 6221 7198034 Web

AW: Get the job id for a hive query

2013-02-28 Thread Tim Bittersohl
I’m trying to get the job id of the job created with a Hive query. At the moment I can get the cluster status from the HiveClient, but I don’ find any job id in there... Tim Bittersohl Software Engineer http://www.innoplexia.de/ci/logo/inno_logo_links%20200x80.png Innoplexia GmbH

Get the job id for a hive query

2013-02-27 Thread Tim Bittersohl
Hi, has the Hive client the possibility to give back the job id of the job created when running a query? I need that for tracking. Greetings Tim Bittersohl Software Engineer http://www.innoplexia.de/ci/logo/inno_logo_links%20200x80.png Innoplexia GmbH Mannheimer Str. 175 69123