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
