drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1272) Support CAST() functions for HBase filter pushdown
Date Fri, 10 Oct 2014 18:31:34 GMT

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

Aditya Kishore updated DRILL-1272:
----------------------------------
            Priority: Major  (was: Critical)
    Target Version/s: Future
       Fix Version/s:     (was: 0.7.0)
                      Future
          Issue Type: New Feature  (was: Bug)
             Summary: Support CAST() functions for HBase filter pushdown  (was: Filters are
not being pushed down to hbase from drill)

> Support CAST() functions for HBase filter pushdown
> --------------------------------------------------
>
>                 Key: DRILL-1272
>                 URL: https://issues.apache.org/jira/browse/DRILL-1272
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Storage - HBase
>            Reporter: Krystal
>            Assignee: Aditya Kishore
>             Fix For: Future
>
>
> git.commit.id.abbrev=98b208e
> I ran the following queries in drill:
> explain plan for select cast(row_key as integer) voter_id, convert_from(onecf['name'],
'UTF8') name, cast(twocf['age'] as integer) age, cast(twocf['registration'] as varchar(20))
registration, cast(threecf['contributions'] as decimal(6,2)) contributions, cast(threecf['voterzone']
as integer) voterzone,cast(fourcf['create_date'] as timestamp) create_date from voter where
onecf['name'] not similar to '%(young|u|a)%';
> explain plan for 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'])
where cast(student.twocf['age'] as integer) = 70;
> explain plan for 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'])
where cast(student.twocf['age'] as integer) > 70;
> The explain plans for each of the query shows the following:
>  "graph" : [ {
>     "pop" : "hbase-scan",
>     "@id" : 5,
>     "hbaseScanSpec" : {
>       "tableName" : "voter",
>       "startRow" : null,
>       "stopRow" : null,
>       "serializedFilter" : null
>     },
> Looks like the serializedFilter should not be null.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message