Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-512

HBase/Hive/Impala Boolean different to Hive/Impala value

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Works for Me
    • Affects Version/s: Impala 1.1
    • Fix Version/s: Impala 1.2
    • Component/s: None
    • Environment:
      Debian 6 CDH 4.3.0

      Description

      I have 2 two tables:

      • One table1 is a a Hive external table from a HBase table with a boolean type field (stored as binary) (true/false)
      • A second table2 is a classic Hive table with a boolean type field (true/false)

      When I'm trying to join these two tables, I can only join when the boolean field = false but not when the boolean field = true.

      Futhermore, when I'm running a query like :
      select * from table1 where booleanField = 0 # I got results with booleanField = false
      select * from table2 where booleanField = 0 # I got results with booleanField = false

      This is normal I think. But when I'm trying with true, I got:
      select * from table1 where booleanField = 1 # I got no result
      select * from table2 where booleanField = 1 # I got results with booleanField = true

      If I do this for table1, I got the true results for the booleanField:
      select * from table1 where booleanField = -1 # I got results with booleanField = true
      select * from table2 where booleanField = -1 # I got no result

      Is this normal ? Am I doing something not expected ? I've tried to refresh both table before initiating the queries in case too.

        Attachments

          Activity

            People

            • Assignee:
              alex.behm Alexander Behm
              Reporter:
              nphung Nicolas PHUNG
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: