You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Violette (JIRA)" <ji...@apache.org> on 2014/03/05 01:58:45 UTC
[jira] [Commented] (PHOENIX-109) Tables with schemas are not found.
[ https://issues.apache.org/jira/browse/PHOENIX-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13920313#comment-13920313 ]
James Violette commented on PHOENIX-109:
----------------------------------------
Repro:
Create the table MYSCHEMA.MYTABLE using 2.2.3
Load CSV data using MYSCHEMA.MYTABLE.csv using 2.2.3
Query MYSCHEMA.MYTABLE.QUERY.sql using 2.2.3
this works.
Upgrade to 3.0.0-SNAPSHOT
Query MYSCHEMA.MYTABLE.QUERY.sql using 3.0.0-SNAPSHOT... this does not work. See exception above.
Repeat these steps for WEB_STAT table. This works correctly across 2.2.3 and 3.0.0-SNAPSHOT. There is no schema.
Also, within a tool such as SQUIREL, schemas do not show up in the table picker. (I used DbVisualizer).
> 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
> Attachments: MYSCHEMA.MYTABLE.QUERY.sql, MYSCHEMA.MYTABLE.csv, MYSCHEMA.MYTABLE.sql, WEB_STAT.QUERY.sql, WEB_STAT.csv, web_stat.sql
>
>
> 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)