Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Amazon EMR error


Sorry guys , not sure if I should request help with this error here because  its an error on Amazon EMR Hive
But you guys have been my Hive fraternity for about 2 years now  and I thought it best to turn to u for help first 

Amazon Hive version 
===============
AMI version:2.4.2
Hadoop distribution:Amazon 1.0.3
Applications:Hive 0.11.0.1

HIVE TABLE
=======
DROP TABLE  solar_installs;
CREATE EXTERNAL TABLE  IF NOT EXISTS solar_installs(
   zipcode STRING,
   state STRING,
   sizekw DOUBLE,
   cost   DOUBLE,
   date_  STRING,
   lat     DOUBLE,
   lon     DOUBLE) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
;
ALTER TABLE solar_installs SET LOCATION 's3://solarinstallations/data'
;

DATA SET SAMPLE 
==============
19801,DE,230.6,,12/30/2014,39.7402405,-75.5521456
80005,CO,7.1,12000.0,01/28/2014,39.851157,-105.132533
19968,DE,5.2,,01/27/2014,38.7776124,-75.3099136
52314,IA,30.0,116900.0,01/17/2014,41.901451,-91.48409
33414,FL,9.28,34000.0,01/16/2014,26.667321,-80.215585
19808,DE,5.2,,01/16/2014,39.721215,-75.668342
19702,DE,7.28,,01/16/2014,39.649586,-75.6998009
19958,DE,5.5,,01/16/2014,38.7638163,-75.1778853
19958,DE,10.56,,01/15/2014,38.7638163,-75.1778853
19958,DE,4.5,,01/15/2014,38.708142,-75.214294
06410,CT,860.0,,01/14/2014,41.5589919,-72.912401
05701,VT,140.4,,01/14/2014,43.598277,-72.955117
19971,DE,7.8,,01/13/2014,38.734048,-75.126563
19971,DE,4.06,,01/13/2014,38.7020005,-75.0961549

QUERY 
=====
hive -e "select zipcode, count(*) from solar_installs group by zipcode"

ERROR
=====
java.lang.RuntimeException: java.lang.IllegalArgumentException: Can not create a Path from an empty string at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:167) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:441) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:377) at org.apache.hadoop.mapred.Child$4.run(Child.java:255) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1132) at org.apache.hadoop.mapred.Child.main(Child.java:249)
Caused by: java.lang.IllegalArgumentException: Can not create a Path from an empty string at org.apache.hadoop.fs.Path.checkPathArg(Path.java:82) at org.apache.hadoop.fs.Path.<init>(Path.java:90) at org.apache.hadoop.hive.ql.exec.MapOperator.cleanUpInputFileChangedOp(MapOperator.java:588) at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1377) at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:611) at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:149) ... 8 more
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB