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

Error execute select command line sqlline -u -q

    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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: