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

Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.9.0
    • Component/s: Storage - HBase
    • Labels:
      None

      Description

      git.commit.id.abbrev=4d398ed

      I created a view on top of hbase table using the below DDL :

      create or replace view dfs.`cross-sources`.fewtypes_null_hbase_booleanbug_view as
      select
          cast(cast(a.types.int_col as varchar(100)) as int) int_col,
          cast(cast(a.types.bool_col as varchar(100)) as boolean) bool_col
      from hbase.fewtypes_null a;
      

      The below query fails :

      select o.bool_col
      from dfs.`cross-sources`.`fewtypes_null.parquet` p
      inner join dfs.`cross-sources`.fewtypes_null_hbase_booleanbug_view o
          on p.int_col=o.int_col;
      Query failed: RemoteRpcException: Failure while trying to start remote fragment, Expression has syntax error! line 1:65:no viable alternative at input 'BIT' [ 6e771b83-e3e3-405d-b738-1cd7ee8d5cb5 on qa-node114.qa.lab:31010 ]
      

      Just projecting the boolean column from hbase succeeds

      select o.bool_col from dfs.`cross-sources`.fewtypes_null_hbase_booleanbug_view o;
      +------------+
      |  bool_col  |
      +------------+
      | false      |
      | false      |
      | true       |
      | false      |
      | false      |
      | true       |
      | false      |
      | true       |
      | true       |
      | false      |
      | true       |
      | false      |
      | false      |
      | false      |
      | true       |
      | false      |
      | true       |
      +------------+
      17 rows selected (1.366 seconds)
      

      I attached the data files, hive script to load data into hbase, and the error log. Let me know if you need anything

        Attachments

        1. error.log
          21 kB
          Rahul Kumar Challapalli
        2. dataload.hql
          1 kB
          Rahul Kumar Challapalli
        3. fewtypes_null_hbase.tbl
          2 kB
          Rahul Kumar Challapalli
        4. fewtypes_null.parquet
          2 kB
          Rahul Kumar Challapalli

          Issue Links

            Activity

              People

              • Assignee:
                adityakishore Aditya Kishore
                Reporter:
                rkins Rahul Kumar Challapalli
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: