FAQ
Here is the table info, and the query is "select acctbal, availqty, partkey from partsupp JOIN supplier ON (partsupp.suppkey == supplier.suppkey); "

desc formatted supplier;
OK
# col_name data_type comment

key string None
acctbal string None
address string None
name string None
nationkey bigint None
phone string None
suppkey bigint None

# Detailed Table Information
Database: default
Owner: hadoop
CreateTime: Wed Sep 21 13:05:50 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://localhost:9000/user/hive/warehouse/supplier
Table Type: MANAGED_TABLE
Table Parameters:
transient_lastDdlTime 1316635649

# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
field.delim ,
serialization.format ,
Time taken: 0.213 seconds


desc formatted partsupp;
OK
# col_name data_type comment

key string None
availqty int None
partkey bigint None
suppkey bigint None
supplycost double None

# Detailed Table Information
Database: default
Owner: hadoop
CreateTime: Wed Sep 21 13:05:37 PDT 2011
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://localhost:9000/user/hive/warehouse/partsupp
Table Type: MANAGED_TABLE
Table Parameters:
transient_lastDdlTime 1316635698

# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
field.delim ,
serialization.format ,
Time taken: 2.192 seconds

On Sep 21, 2011, at 2:10 PM, Ayon Sinha wrote:

If you can share details of your tables and query we might be able to help. Do a desc formatted <tablename>

-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.

From: Krish Khambadkone <kkhambadkone@apple.com>
To: user@hive.apache.org
Sent: Wednesday, September 21, 2011 1:11 PM
Subject: Exception when joining HIVE tables

Hi, I get this exception when I try to join two hive tables or even when I use a specific WHERE clause. "SELECT *" from any individual table seems to work fine. Any idea what is missing here. I am on hive version hive-0.7.0-cdh3u0.

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.fs.Path.<init>(Path.java:50)
at org.apache.hadoop.mapred.JobClient.copyRemoteFiles(JobClient.java:608)
at org.apache.hadoop.mapred.JobClient.copyAndConfigureFiles(JobClient.java:713)
at org.apache.hadoop.mapred.JobClient.copyAndConfigureFiles(JobClient.java:637)
at org.apache.hadoop.mapred.JobClient.access$300(JobClient.java:170)
at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:848)
at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:833)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115)
at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:833)
at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:807)
at org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:657)
at org.apache.hadoop.hive.ql.exec.MapRedTask.execute(MapRedTask.java:123)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:186)
Job Submission failed with exception 'java.lang.IllegalArgumentException(Can not create a Path from an empty string)'
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 7 | next ›
Discussion Overview
groupuser @
categorieshive, hadoop
postedSep 21, '11 at 8:12p
activeSep 22, '11 at 2:29a
posts7
users3
websitehive.apache.org

People

Translate

site design / logo © 2021 Grokbase