[ https://issues.apache.org/jira/browse/DRILL-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-1277. -------------------------- Bug already verified as fixed. Test case added. > 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 > Assignee: DrillCommitter > Fix For: 0.5.0 > > Attachments: DRILL-1277.patch > > > 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.3.4#6332)