Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6917

Column alias not working properly in Python

    XMLWordPrintableJSON

Details

    • If the JDBC column label is set, phoenixdb now uses it as the python DB2 API column description name field, and uses it as the key for DictCursor.

    Description

      Get the columnLabel (the “as name”) rather than the columnName with a cursor.

      calcite 💎:sql> select c1 as hello, c2 as world from int_tbl;
+-------------+-------------+
| c1          | c2          |
|-------------+-------------|
| 5           | 0           |
| -123        | 123         |
| 1           | 123456      |
| -123456     | -123456     |
| 10          | 50          |
| -2147483648 | 1           |
| 2147483647  | -2147483648 |
| <null>      | 10          |
| <null>      | <null>      |
| 1           | 1           |
+-------------+-------------+

       

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. PHOENIX-6920 PhoenixResultSetMetaData doesn't distinguish between label and column_name

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #124

          Activity

            People

              satyakommula Satya Kommula
              satyakommula Satya Kommula
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: