Jdbc driver configuration


The configuration parameters and their default values
No. Property Name Default Value Description
1 lens.cube.query.driver.supported.storages List of comma separated storage names that supported by a driver. If no value is specified, all storages are valid
2 lens.cube.query.enable.multi.table.select false Tells whether multiple tables are allowed in from clause of final HQL query
3 lens.cube.query.partition.where.clause.format yyyy-MM-dd HH:mm:ss The simple date format of how the queried partition should be put in where clause. If nothing is specified, it will use the format from org.apache.lens.cube.metadata.UpdatePeriod for each type of partition
4 lens.cube.query.replace.timedim false Tells whether timedim attribute queried in the time range should be replaced with its corresponding partition column name.
5 lens.cube.query.time.range.writer.class org.apache.lens.cube.parse.BetweenTimeRangeWriter The timerange writer class which specifies how the resolved partitions in timeranges should be written in final query. Available writers are org.apache.lens.cube.parse.ORTimeRangeWriter and org.apache.lens.cube.parse.BetweenTimeRangeWriter
6 lens.driver.jdbc.connection.provider A contract for obtaining JDBC connections
7 lens.driver.jdbc.db.password The database user's password
8 lens.driver.jdbc.db.uri JDBC connection URL in the format jdbc:dbms://host:port/dbname
9 lens.driver.jdbc.db.user The database user on whose behalf the connection is being made
10 lens.driver.jdbc.driver.class com.mysql.jdbc.Driver Type of JDBC driver used to connect backend database
11 lens.driver.jdbc.enable.resultset.streaming.retrieval false Flag to enable row by row retrieval of result set from the database server. This is used to enable streaming result sets for MySQL. This is set to false by default.
12 lens.driver.jdbc.explain.keyword Explain Explain keyword used to get the query plan of underlying database
13 lens.driver.jdbc.fetch.size 1000 Fetch size for JDBC result set
14 lens.driver.jdbc.get.connection.timeout 10000 Response timeout in milliseconds of any JDBC call invoking data transmission over a connection socket
15 lens.driver.jdbc.pool.idle.time 600 Maximum idle time in sec before a connection is closed
16 lens.driver.jdbc.pool.max.size 15 Maximum number of concurrent connections allowed in pool
17 lens.driver.jdbc.pool.max.statements 20 Maximum number of prepared statements to cache per connection
18 lens.driver.jdbc.query.rewriter org.apache.lens.driver.jdbc.ColumnarSQLRewriter Rewriting the HQL to optimized sql queries
19 lens.driver.jdbc.validate.through.prepare true Flag to enable query syntactic and semantic validation using prepared statement.