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

Error execute select command line sqlline -u -q

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

Details

    Description

      I'm newbie with Drill and Jira, so sorry if this is not the correct site.

      When I query : "sqlline -u 'jdbc:drill:drillbit=localhost' -q 'select * from hive.database.table;' " return:

      "select anaconda-ks.cfg build.out install.log install.log.syslog ranger_tutorial sandbox.info start_ambari.sh start_hbase.sh start_solr.sh stop_solr.sh from hive.database.table;"
      Error: PARSE ERROR: Encountered "." at line 1, column 29.
      Was expecting one of:
      "FROM" ...
      "," ...

      So, to fix this, i should type all columns to do this one work.

      But, if I used UI, in localhost:8047/query, the query works. Drill is connected to Hive with plugin of course. Is this a bug or something? Bad conf.?

      Attachments

        Activity

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

          People

            arina Arina Ielchiieva
            jnmgr Jon
            Vitalii Diravka Vitalii Diravka
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment