Re: reflect UDF can't handle both String and int

2012-10-25 Thread Navis류승우
It seemed a bug. I've booked it on https://issues.apache.org/jira/browse/HIVE-3622 2012/10/26 Alexander Ershov > Query > select reflect('java.lang.Integer', 'parseInt', 'a', 16) from src limit 1; > > throws java.lang.NoSuchMethodException: java.lang.Integer.parseInt(null, > int) > > A bug or a f

Re: Hive table backed by a txt file on S3

2012-10-25 Thread John Omernik
Try putting the location to the directory the file is in. If there are other files you don't want to be included make a subdir. On Thu, Oct 25, 2012 at 6:26 AM, Nitin Pawar wrote: > In that case, it looks like when you do a select * .. its just a cat > operation. > > whats the error you are getti

reflect UDF can't handle both String and int

2012-10-25 Thread Alexander Ershov
Query select reflect('java.lang.Integer', 'parseInt', 'a', 16) from src limit 1; throws java.lang.NoSuchMethodException: java.lang.Integer.parseInt(null, int) A bug or a feature?

Re: general question on hive client log

2012-10-25 Thread Chen Song
Thanks Nitin. I also found this wiki. But it only documented the hive client log. What about other log files created during a query? Chen On Thu, Oct 25, 2012 at 7:30 AM, Nitin Pawar wrote: > by default hive reads the logging related configs from > hive-log4j.default in conf directory. > if you

Re: Executing queries after setting hive.exec.parallel in hive-site.xml

2012-10-25 Thread Bejoy KS
Hi Chunky This parameter will come into effect only if a query has been parsed to multiple mapreduce jobs and some of them can be executed in parallel. ie all the jobs generated by the query are not linearly dependent and hence needn't be executed sequentially. In all other cases the MR jobs wi

Re: general question on hive client log

2012-10-25 Thread Nitin Pawar
by default hive reads the logging related configs from hive-log4j.default in conf directory. if you want the cwiki page, here it is https://cwiki.apache.org/Hive/languagemanual-cli.html#LanguageManualCli-Logging On Thu, Oct 25, 2012 at 1:15 AM, Chen Song wrote: > I have searched online but cou

Re: Hive table backed by a txt file on S3

2012-10-25 Thread Nitin Pawar
In that case, it looks like when you do a select * .. its just a cat operation. whats the error you are getting when you put something in where clause? If there is no error and you are not getting any result but you expect a result then the data loaded into table is not in the format you wanted.

Re: Executing queries after setting hive.exec.parallel in hive-site.xml

2012-10-25 Thread Nitin Pawar
this parameter is a query execution optimization approach. hive.exec.parallel if set to true, hive determines that if few stages of your mapreduce job can run independently and if yes then schedules them accordingly. If you set this value in hive-site.xml and wants to see its set or not, then use

Executing queries after setting hive.exec.parallel in hive-site.xml

2012-10-25 Thread Chunky Gupta
Hi , I have 2 questions regarding the parameter 'hive.exec.parallel' in hive-site.xml in ~/.versions/hive-0.8.1/conf/ 1. how do I verify from query log files or from any other way, that a particular query is executing with this parameter set to true. 2. Is it advisable to set this parameter for r