Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4425

Handle blank column names in Hbase in CONVERT_FROM

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.3.0
    • Fix Version/s: None
    • Component/s: Storage - HBase
    • Labels:
    • Environment:

      Apache Drill 1.3 on HortonWorks HDP VM 2.1

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              saurabh.8189 Saurabh Nigam
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: