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
org.apache.hadoop.hive.ql.exec.MapRedTask Von: shrikanth shankar [mailto:sshan...@qubole.com] 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

AW: Hive query problem on S3 table

2013-04-18 Thread Tim Bittersohl
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 2013 16:25 An: user@hive.apache.org Betreff: Re: Hive query problem on S3 table I'm not

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

Re: Hive query problem on S3 table

2013-04-18 Thread Dean Wampler
I'm not 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 default f

Re: Hive query problem on S3 table

2013-04-18 Thread Panshul Whisper
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 file system of > Hadoop. > > The location in the create table command has just to be changed: > > ** ** > > CREA