Re: hive query error

2013-08-21 Thread
thanks Bing I found it 2013/8/22 Bing Li > By default, hive.log should exist in /tmp/. > Also, it could be set in $HIVE_HOME/conf/hive-log4j.properties and > hive-exec-log4j.properties > - hive.log.dir > - hive.log.file > > > 2013/8/22 闫昆 > >> hi all >>

FileNotFoundException

2013-08-21 Thread
hi all i exec hive (zh_site)> select id, >longitude, >latitude, >month, >round(avg(sd), 2) as avgsd > from data_zh > where id between '5' and '6' >and mon

Re: only one mapper

2013-08-21 Thread
the same directory, it would not split > the large file. > > > On Thu, Aug 22, 2013 at 7:11 AM, 闫昆 wrote: > >> In hive i use SET >> mapreduce.input.fileinputformat.split.maxsize=134217728; but not effect and >> i found when use >> >> LOAD DATA INPATH &#

hive query error

2013-08-21 Thread
hi all when exec hive query throw exception as follow I donnot know where is error log I found $HIVE_HOME/ logs not exist Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks not specified. Estimated from input data size: 3 In order to change the average load for a reducer (in

Re: only one mapper

2013-08-21 Thread
ed. > > Snappy + SequenceFile is a better option then LZO. > > > On Wed, Aug 21, 2013 at 1:39 PM, Igor Tatarinov wrote: > >> LZO files are combinable so check your max split setting. >> >> http://mail-archives.apache.org/mod_mbox/hive-user/201107.mbox/%3c4e3

only one mapper

2013-08-21 Thread
hi all when i use hive hive job make only one mapper actually my file split 18 block my block size is 128MB and data size 2GB i use lzo compression and create file.lzo and make index file.lzo.index i use hive 0.10.0 Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks is set to

cannot find class com.hadoop.mapred.DeprecatedLzoTextInputFormat

2013-08-20 Thread
Diagnostic Messages for this Task: Error: java.io.IOException: cannot find class com.hadoop.mapred.DeprecatedLzoTextInputFormat i add hadoop-lzoxx.jar to $HIVE_HOME/lib but it not effect show me the same exception,who can tell me why? And what should i do thank for you help -- In the Hadoo