Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3779

HBase query issues

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7
    • None
    • Misc. Connectors
    • None
    • Hide
      TEIID-3779 - There are a host of Phoenix issues that Teiid is currently not working around for HBase access. If you hit any of these, please let us know so that we can work with the Phoenix community to get it resolved. Generally Phoenix has issues with subquery evaluation and certain datatypes, such as char and timestamp.
      * TEIID-3772 TEIID-3769 TEIID-3766 are not likely to occur and generate an exception.
      * TEIID-3774 is unlikely but can return inaccurate results.
      * TEIID-3768 affects correlated subquery comparison using an aggregate of a char value and can return inaccurate results.
      Show
      TEIID-3779 - There are a host of Phoenix issues that Teiid is currently not working around for HBase access. If you hit any of these, please let us know so that we can work with the Phoenix community to get it resolved. Generally Phoenix has issues with subquery evaluation and certain datatypes, such as char and timestamp. * TEIID-3772 TEIID-3769 TEIID-3766 are not likely to occur and generate an exception. * TEIID-3774 is unlikely but can return inaccurate results. * TEIID-3768 affects correlated subquery comparison using an aggregate of a char value and can return inaccurate results.

    Description

      Hbase has a number of issues with their sql handling / driver. Adding a parent issue to track all of known issues.

      Attachments

        Issue Links

          incorporates

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3766 HBase - using timestamp value with ALL (quantified comparison predicate) throws IllegalArgumentException

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3768 HBase - Phoenix does not evaluate query correctly

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3769 Teiid throws exception while reading result from HBase (Phoenix JDBC driver)

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3770 HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3774 HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null' to true

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3765 HBase - Phoenix does not support scalar subquery

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3772 HBase - Phoenix returns more than one result for subquery which should return only one row

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: