You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Saurabh Nigam (JIRA)" <ji...@apache.org> on 2016/02/23 17:24:18 UTC
[jira] [Created] (DRILL-4425) Handle blank column names in Hbase in
CONVERT_FROM
Saurabh Nigam created DRILL-4425:
------------------------------------
Summary: 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
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)