I'm trying to use JOOQ for quering Hive. Hive SQL dialect is pretty clode
to MySQL dialect. Right now I've met these problems:
- Hive supports LIMIT N, it doesn't support LIMIT N OFFSET K. Dummy
solution - override*select.limit(limit);*
What are best practices resolving such problems in JOOQ?
I've used debugger and found *class org.jooq.impl.Limit*
It's the point where I should introduce my changes.
case SQLITE: {
context.castMode(NEVER)
.formatSeparator()
.keyword("limit ")
.sql(numberOfRows)
.keyword(" offset ")
.sql(offsetOrZero)
.castMode(castMode);
break;
}
I would like to do something like:
case SQLITE: {
context.castMode(NEVER)
.formatSeparator()
.keyword("limit ")
.sql(numberOfRows)
// .keyword(" offset ")
// .sql(offsetOrZero)
.castMode(castMode);
break;
}
How can I do it?
--
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/groups/opt_out.
