[
https://issues.apache.org/jira/browse/PHOENIX-1732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14360049#comment-14360049
]
junweihuang commented on PHOENIX-1732:
--------------------------------------
I use:select * from xx local index is not work. select x,x from xx, it works
> sqlline.py some error message
> -----------------------------
>
> Key: PHOENIX-1732
> URL: https://issues.apache.org/jira/browse/PHOENIX-1732
> Project: Phoenix
> Issue Type: Bug
> Environment: hadoop1.1.2 hbase0.98.1
> Reporter: junweihuang
> Fix For: 4.1
>
>
> 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!!!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
