Exception previewing data from Optiq

[Dan]

Hi,

When i preview a very simple query from optiq in PDI I now get the error below.  Note I had to upgrade few pdi libraries in order to actually get optiq happy but this seems to be within the realm of optiqs code right?

Thanks again!

Dan

2013/10/24 19:58:48 - Version checker - OK

2013/10/24 19:59:03 - /home/codek/projects/pditests/readall.ktr : readall - Dispatching started for transformation [/home/codek/projects/pditests/readall.ktr : readall]

2013/10/24 19:59:04 - Table input.0 - ERROR (version TRUNK-SNAPSHOT, build 1 from 2013-10-21 23.11.41 by tomcat) : Unexpected error

2013/10/24 19:59:04 - Table input.0 - ERROR (version TRUNK-SNAPSHOT, build 1 from 2013-10-21 23.11.41 by tomcat) : java.lang.AbstractMethodError: Baz$3.apply(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.linq4j.EnumerableDefaults.aggregate(EnumerableDefaults.java:86)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.linq4j.DefaultEnumerable.aggregate(DefaultEnumerable.java:88)

2013/10/24 19:59:04 - Table input.0 - at Baz.bind(Baz.java:64)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.getEnumerable(OptiqPrepare.java:193)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.enumerator(OptiqPrepare.java:203)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqStatement$1.apply(OptiqStatement.java:377)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqStatement$1.apply(OptiqStatement.java:375)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqResultSet.execute(OptiqResultSet.java:157)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqStatement.executeQueryInternal(OptiqStatement.java:365)

2013/10/24 19:59:04 - Table input.0 - at net.hydromatic.optiq.jdbc.OptiqStatement.executeQuery(OptiqStatement.java:80)

2013/10/24 19:59:04 - Table input.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1640)

2013/10/24 19:59:04 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:224)

2013/10/24 19:59:04 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:138)

2013/10/24 19:59:04 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:61)

2013/10/24 19:59:04 - Table input.0 - at java.lang.Thread.run(Thread.java:722)

2013/10/24 19:59:04 - Table input.0 - Finished reading query, closing connection.

2013/10/24 19:59:04 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)

2013/10/24 19:59:04 - /home/codek/projects/pditests/readall.ktr : readall - /home/codek/projects/pditests/readall.ktr : readall

2013/10/24 19:59:04 - /home/codek/projects/pditests/readall.ktr : readall - /home/codek/projects/pditests/readall.ktr : readall

[Julian Hyde]

Please log a bug for that. Yes, it’s an optiq issue, but might be hard to reproduce without a test case.

Post the SQL statement, and turn on “-Doptiq.debug=true” and post what gets printed to stdout.

Julian

--
You received this message because you are subscribed to the Google Groups "optiq-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to optiq-dev+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Dan Keeley]

Great. I just raised: https://github.com/julianhyde/optiq/issues/67

Apologies for the tardy reply; I didn't see the response as I hadn't subscribed to email notifications, doh!

Just to repeat what I put in the ticket - the problem is specific to select count(*) from  style queries.  Is it not setting the return type of a count(*) function or something funny like that?

Reproduced with emps and my own tdata datasource.

Dan

[Vladimir Sitnikov]

Hi,

The issue was migrated to https://issues.apache.org/jira/browse/CALCITE-67

As far as I understand the issue is fixed somehow as the following works in current Calcite:

@Test public void testGroupStarSalesEmps() {
  CalciteAssert.that()
      .with(CalciteAssert.Config.LINGUAL)
      .query("select count(*) as c\n"
          + "from sales.emps")
      .returnsUnordered(
          "C=2");
}

Vladimir