*Hi,* I've been using jooq to write hive sql statement. I found SQLite to be very similar to the Hive dialect, but there certain differences like the offset clause, which is not supported in hive.
I was wondering if there is a way to extend/update sql clauses of query parts to update/change the expected behavior of jOOQ when toSQL() method is used? I followed the recommendations on this one-year old topic: https://groups.google.com/forum/?hl=es#!searchin/jooq-user/hive/jooq-user/Nt7cc7QnFqI/wslQw2DiyWIJ I believe ExecuteListener cannot be used in this case, because the sql queries being constructed using the SQLite dialect are never executed through jOOQ. I only extract the sql string using toSQL(). I tried using VisitListener but I haven't been able to found the Clause or QueryPart associated with LIMIT or OFFSET. Another thing that is different between Hive and SQLite is the INSERT INTO clause. In hive, you have to write the complete INSERT INTO TABLE expression. This is another piece I would like to change/extend. Is there any way I could possibly accomplish my previous two use cases: 1) Getting rid of the OFFSET piece 2) Adding "TABLE" to the INSERT INTO clause Thanks in advance for your answer and guidance, *Claudia* -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
