phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-109) Tables with schemas are not found.
Date Fri, 02 May 2014 05:06:15 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor resolved PHOENIX-109.
----------------------------------

    Resolution: Invalid

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

Mime
View raw message