Hi Vikas, As Rajat mentioned JDBC driver can add a dbname.table name.
You can check these two propertie which have to be set in the Storage table - lens.metastore.native.db.name lens.metastore.native.table.name Relevant code - ColumnarSQLRewriter. replaceWithUnderlyingStorage Thanks, Jaideep On Fri, Apr 17, 2015 at 1:35 PM, Rajat Khandelwal <[email protected]> wrote: > 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 > > > -- - Jaideep Dhok -- _____________________________________________________________ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The firm is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.
