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

Join does not work in Hbase

    XMLWordPrintableJSON

Details

    Description

      git.commit.id.abbrev=29dde76

      The below query which joins 2 hbase tables fails with the below error

      select student.onecf['name'] name from student inner join voter on (student.onecf['name'] = voter.onecf['name']);
      Query failed: Failure while running fragment. Failure finding function that runtime code generation expected.  Signature: compare_to( VARBINARY:OPTIONALINT:OPTIONAL,  ) returns INT:REQUIRED [0ffd82e9-43ac-4a29-934f-b72fa76ddb78]
      

      Attached the data and log files

      Attachments

        1. votertab
          62 kB
          Rahul Kumar Challapalli
        2. studenttab
          57 kB
          Rahul Kumar Challapalli
        3. error.txt
          21 kB
          Rahul Kumar Challapalli

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rkins Rahul Kumar Challapalli
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: