drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Altekruse (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4425) Handle blank column names in Hbase in CONVERT_FROM
Date Tue, 23 Feb 2016 16:49:18 GMT

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

Jason Altekruse commented on DRILL-4425:
----------------------------------------

I'm not sure that a blank column name is valid SQL, I am pretty sure most databases reject
it.

It looks like `` gets rejected at the validation stage in Drill, but I believe this is the
right behavior.

Why would anyone ever use a blank column name? Is this a commonly used feature of HBase?

While we want to fully support the systems we plug into, some patterns found in particular
systems just don't conform the SQL model, and implementing this would mean removing a reasonable
check from the SQL validator.

> Handle blank column names in Hbase in CONVERT_FROM
> --------------------------------------------------
>
>                 Key: DRILL-4425
>                 URL: https://issues.apache.org/jira/browse/DRILL-4425
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Storage - HBase
>    Affects Versions: 1.3.0
>         Environment: Apache Drill 1.3 on HortonWorks HDP VM 2.1
>            Reporter: Saurabh Nigam
>            Priority: Critical
>              Labels: easyfix
>
> Hbase table may contain blank column names & blank column family names. Drill needs
to handle such situation.
> I faced the issue when I had a column with blank column name in my Hbase Table. To reproduce
it :
> -Create a column without any name in Hbase
> -Try to access it via Drill console
> -Try to use CONVERT_FROM function to convert that data from Base64 encoding to make it
readable. You wont be able to convert blank column because you cannot use blank in your query
after a dot.
> Something like  this
> SELECT CONVERT_FROM(students. , 'UTF8') AS zipcode 
>  FROM students;
> Where column name is blank
> We need to provide a placeholder for blank column names



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

Mime
View raw message