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