drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1277) Join between 2 hbase/M7 tables using the dot notation fails
Date Wed, 20 Aug 2014 18:36:26 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14104301#comment-14104301
] 

Krystal commented on DRILL-1277:
--------------------------------

git.commit.id.abbrev=654c879

Verified that bug is fixed.

> 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.2#6252)

Mime
View raw message