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

Error execute select command line sqlline -u -q

    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

        Issue Links

          Activity

            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: