Rahul Challapalli created DRILL-735:
---------------------------------------
Summary: Drill fails when querying hive tables which have a
varchar dataype
Key: DRILL-735
URL: https://issues.apache.org/jira/browse/DRILL-735
Project: Apache Drill
Issue Type: Bug
Reporter: Rahul Challapalli
Create a hive table
DROP TABLE IF EXISTS HIVESTUDENTS;
CREATE EXTERNAL TABLE HIVESTUDENTS
(
ID VARCHAR(24),
NAME VARCHAR(24),
STREET VARCHAR(256),
ZIPCODE INT,
STATE VARCHAR(20),
PERCENTAGE DECIMAL
)
ROW FORMAT DELIMITED FIELDS
TERMINATED BY ','
STORED AS TEXTFILE LOCATION "/drill/testdata/students/";
2. Make sure the queries are working fine in hive
3. Query from drill :
select count(*) from hive.hivestudents;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "a90db583-9a1c-48b1-9b04-e72014e76f28"
endpoint {
address: "qa-node190.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < UnsupportedOperationException:[ Could
not determine type: VARCHAR ]"
]
Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
