Re: Hive JOIN fails if SELECT statement contains fields from the first table.

2012-01-16 Thread Mark Grover
x Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. - Original Message - From: "Bing Li" To: dev@hive.apache.org, u...@hive.apache.org Sent: Monday, January 16, 2012 5:06:00 AM Subject: Hive JOIN fails if SELECT statement contains fie

Hive JOIN fails if SELECT statement contains fields from the first table.

2012-01-16 Thread Bing Li
1. I create two Hive table: Hive> CREATE EXTERNAL TABLE student_details (studentid INT,studentname STRING,age INT,gpa FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION ‘/home/biadmin/hivetbl'; Hive>CREATE EXTERNAL TABLE student_score(studentid INT, classid INT,scor