drill-issues mailing list archives

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

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

Saurabh Nigam updated DRILL-4425:
---------------------------------
    Description: 
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

  was:
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


> 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