You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2015/12/15 06:19:46 UTC
[jira] [Updated] (TAJO-1874) When querying on pgsql, the generated
query has an error against the table alias
[ https://issues.apache.org/jira/browse/TAJO-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jihoon Son updated TAJO-1874:
-----------------------------
Fix Version/s: (was: 0.11.1)
0.12.0
> When querying on pgsql, the generated query has an error against the table alias
> --------------------------------------------------------------------------------
>
> Key: TAJO-1874
> URL: https://issues.apache.org/jira/browse/TAJO-1874
> Project: Tajo
> Issue Type: Bug
> Components: JDBC Storage
> Reporter: Jihoon Son
> Fix For: 0.12.0
>
>
> Here is the query and the log.
> {noformat}
> tpch> select
> l_orderkey,
> sum(l_extendedprice*(1-l_discount)) as revenue,
> o_orderdate,
> o_shippriority
> from
> pgsql_db.customer as c
> join pgsql_db.orders as o
> on c.c_mktsegment = 'BUILDING' and c.c_custkey = o.o_custkey
> join lineitem as l
> on l.l_orderkey = o.o_orderkey
> where
> o_orderdate < '1995-03-15'::date
> and l_shipdate > '1995-03-15'::date
> group by
> l_orderkey, o_orderdate, o_shippriority
> order by
> revenue desc, o_orderdate;
> ...
> 2015-09-23 01:13:18,136 INFO org.apache.tajo.worker.ExecutionBlockContext: Tajo Root Dir: hdfs://localhost:7020/tajo/warehouse
> 2015-09-23 01:13:18,136 INFO org.apache.tajo.worker.ExecutionBlockContext: Worker Local Dir: /disk2/tajo-tmp
> 2015-09-23 01:13:18,142 INFO org.apache.tajo.storage.jdbc.JdbcScanner: Generated SQL: SELECT o_orderkey,o_custkey,o_orderdate,o_shippriority FROM orders WHERE o.o_orderdate < DATE '1995-03-15'
> 2015-09-23 01:13:18,147 INFO org.apache.tajo.worker.TaskManager: Running ExecutionBlocks: 2, running tasks:1, availableResource: (Memory:2596, Disks:0, vCores:1)
> 2015-09-23 01:13:18,147 INFO org.apache.tajo.worker.TaskImpl: Task basedir is created (file:/disk2/tajo-tmp/q_1442938292784_0001/output/1)
> 2015-09-23 01:13:18,148 INFO org.apache.tajo.worker.TaskImpl: Initializing: ta_1442938292784_0001_000001_000000_00
> 2015-09-23 01:13:18,149 INFO org.apache.tajo.worker.TaskImpl: ==================================
> 2015-09-23 01:13:18,149 INFO org.apache.tajo.worker.TaskImpl: * Stage ta_1442938292784_0001_000001_000000_00 is initialized
> 2015-09-23 01:13:18,149 INFO org.apache.tajo.worker.TaskImpl: * InterQuery: true, Use HASH_SHUFFLE shuffle, Fragments (num: 1), Fetches (total:0) :
> 2015-09-23 01:13:18,149 INFO org.apache.tajo.worker.TaskImpl: * Local task dir: file:/disk2/tajo-tmp/q_1442938292784_0001/output/1/0_0
> 2015-09-23 01:13:18,149 INFO org.apache.tajo.worker.TaskImpl: ==================================
> 2015-09-23 01:13:18,166 ERROR org.apache.tajo.worker.TaskImpl: internal error: ERROR: missing FROM-clause entry for table "o"
> Position: 74
> org.apache.tajo.exception.TajoInternalError: internal error: ERROR: missing FROM-clause entry for table "o"
> Position: 74
> at org.apache.tajo.storage.jdbc.JdbcScanner.executeQueryAndGetIter(JdbcScanner.java:263)
> at org.apache.tajo.storage.jdbc.JdbcScanner.next(JdbcScanner.java:116)
> at org.apache.tajo.engine.planner.physical.FullScanIterator.hasNext(FullScanIterator.java:39)
> at org.apache.tajo.engine.planner.physical.SeqScanExec.next(SeqScanExec.java:292)
> at org.apache.tajo.engine.planner.physical.HashShuffleFileWriteExec.next(HashShuffleFileWriteExec.java:102)
> at org.apache.tajo.worker.TaskImpl.run(TaskImpl.java:405)
> at org.apache.tajo.worker.TaskContainer.run(TaskContainer.java:65)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> 2015-09-23 01:13:18,171 INFO org.apache.tajo.worker.TaskImpl: ta_1442938292784_0001_000002_000000_00 completed. Worker's task counter - total:1, succeeded: 0, killed: 0, failed: 1
> 2015-09-23 01:13:18,173 ERROR org.apache.tajo.querymaster.TaskAttempt: ta_1442938292784_0001_000002_000000_00 FROM jihoon-desktop >> internal error: ERROR: missing FROM-clause entry for table "o"
> Position: 74
> 2015-09-23 01:13:18,173 INFO org.apache.tajo.querymaster.Task: ====================================================================================
> 2015-09-23 01:13:18,173 INFO org.apache.tajo.querymaster.Task: >>> Task Failed: ta_1442938292784_0001_000002_000000_00, retry:true, attempts:1 <<<
> 2015-09-23 01:13:18,173 INFO org.apache.tajo.querymaster.Task: ====================================================================================
> ...
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)