Thanks Julian, this is unfortunate as it undermines the idea of having jdbc wrapper in front of HAWQ.
I will log Jira tickets. How difficult do you think would be to provide DML support for the JDBC adapter? If i am to take a look at it where should look first? Cheers, Christian On 30 November 2016 at 19:23, Julian Hyde <[email protected]> wrote: > It’s a missing feature. The JDBC adapter does not currently do DML. Can > you please log a JIRA case to track. > > Julian > > > > On Nov 30, 2016, at 7:56 AM, Christian Tzolov <[email protected]> > wrote: > > > > A test to reproduce the problem: > > > > @Test public void testJdbcAdapterInsert() { > > > > CalciteAssert.model(JdbcTest.FOODMART_MODEL) > > .enable(CalciteAssert.DB == POSTGRESQL) > > .query("INSERT INTO \"foodmart\".\"expense_fact\"(\n" + > > " \"store_id\", \"account_id\", \"exp_date\", > > \"time_id\"," + > > " \"category_id\", \"currency_id\", > \"amount\")\n" + > > " VALUES (666, 666, TIMESTAMP '1997-01-01 00:00:00', 666, > '666', > > 666, 666)") > > .runs(); > > } > > > > Run with -Dcalcite.test.db=postgresql > > > > > > On 30 November 2016 at 15:37, Christian Tzolov <[email protected]> > wrote: > > > >> Hi, > >> > >> The insert statement via the JdbcAdapter fails with > >> "rel#78:Subset#1.ENUMERABLE.[]] could not be implemented;" > >> > >> I'm testing SQL inserts using the foodmart dataset and postgresql > >> configured as a backend. > >> > >> Following insert works find on postgresql but fails when run through the > >> jdbc adapter: > >> > >> "INSERT INTO "foodmart"."expense_fact"("store_id", "account_id", > >> "exp_date", "time_id", "category_id", "currency_id", "amount") VALUES > (666, > >> 666, TIMESTAMP '1997-01-01 00:00:00', 666, '666', 666, 666); > >> > >> The jdbc-adapter error: > >> > >> Error: Error while executing SQL "INSERT INTO > "foodmart"."expense_fact"("store_id", > >> "account_id", "exp_date", "time_id", "category_id", "currency_id", > >> "amount") VALUES (666, 666, TIMESTAMP '1997-01-01 00:00:00', 666, '666', > >> 666, 666)": Node [rel#78:Subset#1.ENUMERABLE.[]] could not be > >> implemented; planner state: > >> > >> It looks like error occurs before the JdbcTableModificationRule#covert > is > >> reached. > >> > >> Is this a limitation or bug? > >> > >> Thanks, > >> Christian > >> > > > >
