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

Querying 'COLUMNS' AND 'CATALOGS' from INFORMATION_SCHEMA fails with some sort of formatting exception

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 0.9.0
    • Metadata
    • None

    Description

      git.commit.id.abbrev=29dde76

      Querying 'COLUMNS' and 'CATALOGS' tables from INFORMATION_SCHEMA fails

      0: jdbc:drill:schema=dfs.drillTestDirViews> select * from INFORMATION_SCHEMA.`COLUMNS`;
      Query failed: Failure while running fragment. Error: ',', ':', or ';' expected at position 7 from 'decimal(10,0)' [0:decimal, 7:(, 8:10, 10:,, 11:0, 12:)] [54759aa7-1652-4efd-8520-8cad8d3b9899]
      
      Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
      

      Other table in INFORMATION_SCHEMA like 'TABLES', 'VIEWS', and 'SCHEMATA' work fine.

      Attached the error log

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            mehant Mehant Baid
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment