We can add a driver level config option for jdbc driver. And have jdbc driver rewrite using that.
On Fri, Apr 17, 2015 at 12:53 PM Vikas Singh (Tech - VS) < [email protected]> wrote: > Hi > > Problem Statement: > For JDBC datastores i.e. Vertica we are facing problem regarding > schema name resolution. As the actual table against which query will be > fired will be <schema_name>.<table_name>. In lens there is no concept of > schema and I guess directly it's not possible to incorporate a "." (DOT) as > table name since Hive does't support dotted names. > > Proposed Workaround: > - Adding a property schemaName as part of FactTable and DimTables, > which will contain fully resolved table name. > - Doing a query rewrite for schema name at the JDBC driver level. > > Please give your thoughts around this approach. Or if there is any existing > approach to support schema name resolutions. > > Regards > Vikas Singh >
