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

TABLE/COLUMN names in Drill are case sensitive

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: 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
        jnadeau Jacques Nadeau added a comment -

        Should be resolved in 129cd77

        Show
        jnadeau Jacques Nadeau added a comment - Should be resolved in 129cd77
        Hide
        jnadeau 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
        jnadeau 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.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development