[
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)
