Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1732

sqlline.py some error message

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

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • None
    • 4.1.0
    • None
    • None
    • hadoop1.1.2 hbase0.98.1

    Description

      hadoop@hadoop:/home/hjw$ /usr/local/phoenix/hadoop1/bin/sqlline.py localhost
      Setting property: [isolation, TRANSACTION_READ_COMMITTED]
      issuing: !connect jdbc:phoenix:localhost none none org.apache.phoenix.jdbc.PhoenixDriver
      Connecting to jdbc:phoenix:localhost
      15/03/12 20:53:59 WARN util.Tracing: Tracing will outputs will not be written to any metrics sink! No TraceMetricsSink found on the classpath
      java.lang.RuntimeException: Could not create interface org.apache.phoenix.trace.PhoenixSpanReceiver Is the hadoop compatibility jar on the classpath?
      at org.apache.hadoop.hbase.CompatibilityFactory.getInstance(CompatibilityFactory.java:60)
      at org.apache.phoenix.trace.TracingCompat.newTraceMetricSource(TracingCompat.java:40)
      at org.apache.phoenix.trace.util.Tracing.addTraceMetricsSource(Tracing.java:294)
      at org.apache.phoenix.jdbc.PhoenixConnection.<clinit>(PhoenixConnection.java:125)
      at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1516)
      at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489)
      at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
      at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489)
      at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
      at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
      at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
      at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
      at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
      at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
      at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
      at sqlline.SqlLine.dispatch(SqlLine.java:817)
      at sqlline.SqlLine.initArgs(SqlLine.java:633)
      at sqlline.SqlLine.begin(SqlLine.java:680)
      at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
      at sqlline.SqlLine.main(SqlLine.java:424)
      Caused by: java.util.NoSuchElementException
      at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:357)
      at java.util.ServiceLoader$1.next(ServiceLoader.java:445)
      at org.apache.hadoop.hbase.CompatibilityFactory.getInstance(CompatibilityFactory.java:46)
      ... 24 more
      Connected to: Phoenix (version 4.1)
      Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 4.1)
      Autocommit status: true
      Transaction isolation: TRANSACTION_READ_COMMITTED
      Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
      72/72 (100%) Done
      Done
      sqlline version 1.1.2

      another question is:I have create local index but why I use "expain select" that show me "full scan" ,why not range scan.????

      I need your help thank you!!!

      Attachments

        Activity

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

          People

            Unassigned Unassigned
            junweihuang junweihuang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment