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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Works for Me
    • Impala 1.1
    • Impala 1.2
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: