[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-10 Thread Xuefu Zhang (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xuefu Zhang updated HIVE-5446:
--

   Resolution: Fixed
Fix Version/s: 0.13.0
   Status: Resolved  (was: Patch Available)

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Fix For: 0.13.0

 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch, HIVE-5446.5.patch, HIVE-5446.7.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-09 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.6.patch

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch, HIVE-5446.5.patch, HIVE-5446.6.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-09 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: (was: HIVE-5446.6.patch)

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch, HIVE-5446.5.patch, HIVE-5446.7.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-09 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.7.patch

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch, HIVE-5446.5.patch, HIVE-5446.7.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-08 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.5.patch

Update the patch #5 based on [~xuefuz]'s comment in review board

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch, HIVE-5446.5.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-08 Thread Xuefu Zhang (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xuefu Zhang updated HIVE-5446:
--

Status: Patch Available  (was: Open)

Submit the patch to run the test.

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch, HIVE-5446.5.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-07 Thread Thejas M Nair (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Thejas M Nair updated HIVE-5446:


Status: Open  (was: Patch Available)

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-07 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.4.patch

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch, 
 HIVE-5446.4.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-06 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.3.patch

Thanks [~thejas]. Also attached a new patch with the fix for the typo is you 
need.

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch, HIVE-5446.3.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2014-01-02 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.2.patch

Re-based the patch on trunk

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch, HIVE-5446.2.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2013-10-04 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Attachment: HIVE-5446.1.patch

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1#6144)


[jira] [Updated] (HIVE-5446) Hive can CREATE an external table but not SELECT from it when file path have spaces

2013-10-04 Thread Shuaishuai Nie (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-5446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shuaishuai Nie updated HIVE-5446:
-

Status: Patch Available  (was: Open)

 Hive can CREATE an external table but not SELECT from it when file path have 
 spaces
 ---

 Key: HIVE-5446
 URL: https://issues.apache.org/jira/browse/HIVE-5446
 Project: Hive
  Issue Type: Bug
Reporter: Shuaishuai Nie
Assignee: Shuaishuai Nie
 Attachments: HIVE-5446.1.patch


 Create external table table1 (age int, 
 gender string, totBil float, 
 dirBill float, alkphos int,
 sgpt int, sgot int, totProt float, 
 aLB float, aG float, sel int) 
 ROW FORMAT DELIMITED
 FIELDS TERMINATED BY ','
 STORED AS TEXTFILE
 LOCATION 'hdfs://namenodehost:9000/hive newtable';
 select * from table1;
 return nothing even there is file in the target folder



--
This message was sent by Atlassian JIRA
(v6.1#6144)