James Violette created PHOENIX-109:
--------------------------------------
Summary: Tables with schemas are not found.
Key: PHOENIX-109
URL: https://issues.apache.org/jira/browse/PHOENIX-109
Project: Phoenix
Issue Type: Bug
Affects Versions: 3.0.0
Reporter: James Violette
Results using Phoenix 2.2.3
-------------------------------------------------------------------------
$ ./psql.sh blvdevhdp04 ../examples/MYSCHEMA.MYTABLE.sql
no rows upserted
Time: 3.16 sec(s)
$ ./psql.sh blvdevhdp04 ../examples/MYSCHEMA.MYTABLE.csv
csv columns from database.
phoenix columnInfo length=2, org.apache.phoenix.util.ColumnInfo@773c550f,
org.apache.phoenix.util.ColumnInfo@19f488f1
CSV Upsert complete. 3 rows upserted
Time: 0.033 sec(s)
$ ./psql.sh blvdevhdp04 ../examples/MYSCHEMA.MYTABLE.QUERY.sql
NAME INFO
---------- ----------
name1 info1
name2 info2
name3 info3
Time: 0.456 sec(s)
Upgrade to Phoenix 3.0.0-SNAPSHOT (on client and on hbase region servers)
-------------------------------------------------------------------------
Queries against tables without schemas work correctly.
$ ./bin/psql.py blvdevhdp04 examples/WEB_STAT.QUERY.sql
HOST DOMAIN FEATURE DATE CORE DB ACTIVE_VISITOR
---- ---------- ---------- ------------------- -------- -------- --------------
EU Apple.com Mac 2013-01-01 01:01:01 35 22 34
EU Apple.com Store 2013-01-03 01:01:01 345 722 170
EU Google.com Analytics 2013-01-13 08:06:01 25 2 6
EU Google.com Search 2013-01-09 01:01:01 395 922 190
EU Salesforce.com Dashboard 2013-01-06 05:04:05 12 22
43
EU Salesforce.com Login 2013-01-12 01:01:01 5 62
150
EU Salesforce.com Reports 2013-01-02 12:02:01 25 11
2
EU Salesforce.com Reports 2013-01-02 14:32:01 125 131
42
Queries against tables with schemas do not work.
$ ./bin/psql.py blvdevhdp04 examples/MYSCHEMA.MYTABLE.QUERY.sql
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
undefined. tableName=MYSCHEMA.MYTABLE
at
org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:276)
at
org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:193)
at
org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:150)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:262)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:253)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.getParameterMetaData(PhoenixPreparedStatement.java:214)
at
org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:206)
at
org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:252)
at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:196)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
