============================================================================
USER COMMAND:
SELECT * FROM HiveSrc.nyse_stocks

----------------------------------------------------------------------------
OPTIMIZE:
SELECT * FROM HiveSrc.nyse_stocks

----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT * FROM HiveSrc.nyse_stocks

CANONICAL PLAN:
Project(groups=[HiveSrc.nyse_stocks], props={PROJECT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close]})
  Source(groups=[HiveSrc.nyse_stocks])


============================================================================
EXECUTING PlaceAccess

AFTER:
Project(groups=[HiveSrc.nyse_stocks], props={PROJECT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close]})
  Access(groups=[HiveSrc.nyse_stocks], props={MODEL_ID=Schema name=HiveSrc, nameInSource=null, uuid=mmuuid:8af5b7a3-dc77-4277-a27a-cf82e107b5d0})
    Source(groups=[HiveSrc.nyse_stocks])


============================================================================
EXECUTING RaiseAccess

AFTER:
Access(groups=[HiveSrc.nyse_stocks], props={MODEL_ID=Schema name=HiveSrc, nameInSource=null, uuid=mmuuid:8af5b7a3-dc77-4277-a27a-cf82e107b5d0})
  Project(groups=[HiveSrc.nyse_stocks], props={PROJECT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close]})
    Source(groups=[HiveSrc.nyse_stocks])


============================================================================
EXECUTING AssignOutputElements

AFTER:
Access(groups=[HiveSrc.nyse_stocks], props={MODEL_ID=Schema name=HiveSrc, nameInSource=null, uuid=mmuuid:8af5b7a3-dc77-4277-a27a-cf82e107b5d0, OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close]})
  Project(groups=[HiveSrc.nyse_stocks], props={PROJECT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close], OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close]})
    Source(groups=[HiveSrc.nyse_stocks], props={OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close]})


============================================================================
EXECUTING CalculateCost

AFTER:
Access(groups=[HiveSrc.nyse_stocks], props={MODEL_ID=Schema name=HiveSrc, nameInSource=null, uuid=mmuuid:8af5b7a3-dc77-4277-a27a-cf82e107b5d0, OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close], EST_CARDINALITY=-1.0})
  Project(groups=[HiveSrc.nyse_stocks], props={PROJECT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close], OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close], EST_CARDINALITY=-1.0})
    Source(groups=[HiveSrc.nyse_stocks], props={OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close], EST_COL_STATS={HiveSrc.nyse_stocks.exchange=[0.0, 0.0], HiveSrc.nyse_stocks.stock_symbol=[0.0, 0.0], HiveSrc.nyse_stocks."date"=[0.0, 0.0], HiveSrc.nyse_stocks.stock_price_open=[0.0, 0.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING PlanSorts

AFTER:
Access(groups=[HiveSrc.nyse_stocks])
  Project(groups=[HiveSrc.nyse_stocks])
    Source(groups=[HiveSrc.nyse_stocks])


============================================================================
EXECUTING CollapseSource

AFTER:
Access(groups=[HiveSrc.nyse_stocks], props={MODEL_ID=Schema name=HiveSrc, nameInSource=null, uuid=mmuuid:8af5b7a3-dc77-4277-a27a-cf82e107b5d0, OUTPUT_COLS=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close FROM HiveSrc.nyse_stocks})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN =
AccessNode(0) output=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close] SELECT g_0.exchange, g_0.stock_symbol, g_0."date", g_0.stock_price_open, g_0.stock_price_high, g_0.stock_price_low, g_0.stock_price_close, g_0.stock_volume, g_0.stock_price_adj_close FROM HiveSrc.nyse_stocks AS g_0

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(0) output=[HiveSrc.nyse_stocks.exchange, HiveSrc.nyse_stocks.stock_symbol, HiveSrc.nyse_stocks."date", HiveSrc.nyse_stocks.stock_price_open, HiveSrc.nyse_stocks.stock_price_high, HiveSrc.nyse_stocks.stock_price_low, HiveSrc.nyse_stocks.stock_price_close, HiveSrc.nyse_stocks.stock_volume, HiveSrc.nyse_stocks.stock_price_adj_close] SELECT g_0.exchange, g_0.stock_symbol, g_0."date", g_0.stock_price_open, g_0.stock_price_high, g_0.stock_price_low, g_0.stock_price_close, g_0.stock_volume, g_0.stock_price_adj_close FROM HiveSrc.nyse_stocks AS g_0

============================================================================

10:12:42,705 INFO  [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Svfi9IeCjxh8 TEIID11002 Failed to report the JDBC driver and connection information
10:12:42,947 WARN  [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Svfi9IeCjxh8 Connector worker process failed for atomic-request=Svfi9IeCjxh8.0.0.0: org.teiid.translator.jdbc.JDBCExecutionException: 40000 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.exchange, g_0.stock_symbol, g_0.date, g_0.stock_price_open, g_0.stock_price_high, g_0.stock_price_low, g_0.stock_price_close, g_0.stock_volume, g_0.stock_price_adj_close FROM nyse_stocks g_0]
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:254) [teiid-engine-8.4.1.jar:8.4.1]
        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1.jar:8.4.1]
        at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1.jar:8.4.1]
        at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1.jar:8.4.1]
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45]
        at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45]
        at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1.jar:8.4.1]
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1.jar:8.4.1]
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1.jar:8.4.1]
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1.jar:8.4.1]
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]
        at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
Caused by: java.sql.SQLException: Error while processing statement: FAILED: ParseException line 1:11 cannot recognize input near 'g_0' '.' 'exchange' in select expression

        at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:165)
        at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:153)
        at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:198)
        at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:300)
        at org.apache.hive.jdbc.HivePreparedStatement.executeQuery(HivePreparedStatement.java:106)
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
        ... 13 more

10:12:42,952 WARN  [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Svfi9IeCjxh8 TEIID30020 Processing exception for request Svfi9IeCjxh8.0 'TEIID30504 HiveSrc: 40000 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.exchange, g_0.stock_symbol, g_0.date, g_0.stock_price_open, g_0.stock_price_high, g_0.stock_price_low, g_0.stock_price_close, g_0.stock_volume, g_0.stock_price_adj_close FROM nyse_stocks g_0]'. Originally TeiidProcessingException 'Error while processing statement: FAILED: ParseException line 1:11 cannot recognize input near 'g_0' '.' 'exchange' in select expression
' Utils.java:165. Enable more detailed logging to see the entire stacktrace.