Apache Drill
  1. Apache Drill
  2. DRILL-308

SELECT * type queries don't work like standard SQL

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Activity

      Hide
      Mehant Baid added a comment -

      Currently while performing a SELECT * from "foo" we don't get standard SQL type behavior. We get one column with the name "*" and all the actual individual columns are treated like one big column.

      We need to make sure that SELECT * type queries work in the standard SQL manner, where all the columns retrieved are treated as individual fields as opposed to one large field. Challenge lies in how we modify JDBC driver that collects the results, such that the column bindings are delayed till the actual query is executed.

      Show
      Mehant Baid added a comment - Currently while performing a SELECT * from "foo" we don't get standard SQL type behavior. We get one column with the name "*" and all the actual individual columns are treated like one big column. We need to make sure that SELECT * type queries work in the standard SQL manner, where all the columns retrieved are treated as individual fields as opposed to one large field. Challenge lies in how we modify JDBC driver that collects the results, such that the column bindings are delayed till the actual query is executed.

        People

        • Assignee:
          Mehant Baid
          Reporter:
          Mehant Baid
        • Votes:
          0 Vote for this issue
          Watchers:
          1 Start watching this issue

          Dates

          • Created:
            Updated:

            Development