You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/08/08 20:47:14 UTC
[jira] [Created] (DRILL-1277) Join between 2 hbase/M7 tables using
the dot notation fails
Krystal created DRILL-1277:
------------------------------
Summary: Join between 2 hbase/M7 tables using the dot notation fails
Key: DRILL-1277
URL: https://issues.apache.org/jira/browse/DRILL-1277
Project: Apache Drill
Issue Type: Bug
Components: Storage - HBase
Reporter: Krystal
git.commit.id.abbrev=98b208e
I have the following join query between 2 hbase tables that runs successfully:
select cast(student.onecf['name'] as varchar(35)) name, cast(student.twocf['age'] as integer) age, cast(student.threecf['gpa'] as decimal(4,2)) gpa, cast(voter.twocf['registration'] as varchar(20)) registration from student join voter on (student.onecf['name'] = voter.onecf['name']);
I converted the above query to use the dot notation:
select cast(student.onecf.name as varchar(35)) name, cast(student.twocf.age as integer) age, cast(student.threecf.gpa as decimal(4,2)) gpa, cast(voter.twocf.registration as varchar(20)) registration from student join voter on (student.onecf.name = voter.onecf.name);
However this query failed with the following error message:
Query failed: Failure while parsing sql. java.lang.NullPointerException [90df667c-9041-45a2-96c2-8400a6a91f91]
Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)