[jira] [Commented] (DRILL-4425) Handle blank column names in Hbase in CONVERT_FROM

["Jason Altekruse (JIRA)" <ji...@apache.org>]

    [ 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)