Apache Drill
  1. Apache Drill
  2. DRILL-454

TABLE/COLUMN names in Drill are case sensitive

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Drill table/column names seem to be case sensitive.
      Example 1; Select * from INFORMATION_SCHEMA.TABLES works, but INFORMATION_SCHEMA.tables doesn't work

      Example 2: Select * from hive.web_log works , but select * from hive.WEB_LOG doesn't work (this works in hive)

      We need to make the table/column names case-insensitive for ease of use.

        Activity

        Hide
        Jacques Nadeau added a comment -

        I just noticed that this focuses on table names as well as columns. The fix above was for columns. For tables, please verify behavior for non Schema less tables. For schemaless tables, we delegate to the underlying file system which is case sensitive.

        Show
        Jacques Nadeau added a comment - I just noticed that this focuses on table names as well as columns. The fix above was for columns. For tables, please verify behavior for non Schema less tables. For schemaless tables, we delegate to the underlying file system which is case sensitive.
        Hide
        Jacques Nadeau added a comment -

        Should be resolved in 129cd77

        Show
        Jacques Nadeau added a comment - Should be resolved in 129cd77

          People

          • Assignee:
            Unassigned
            Reporter:
            Neeraja
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development