[
https://issues.apache.org/jira/browse/LENS-67?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14229128#comment-14229128
]
Sushil Mohanty edited comment on LENS-67 at 11/30/14 3:04 PM:
--------------------------------------------------------------
To fix the above issue in query rewriter substituting the input alias with
custom alias in the format "db_table_alias" so that the alias is unique. This
new alias will be used for constructing the fact subquery by referring joins
and filter conditions.
was (Author: sushilmohanty):
To fix the above issue in query rewriter substituting the input alias with
custom alias in the format "db"_"table"_"alias" so that the alias is unique.
This new alias will be used for constructing the fact subquery by referring
joins and filter conditions.
> jdbc: queries with alias names for tables are not rewritten correctly
> ----------------------------------------------------------------------
>
> Key: LENS-67
> URL: https://issues.apache.org/jira/browse/LENS-67
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Raghavendra Singh
> Assignee: Sushil Mohanty
>
> Cube Query:-
> {CODE}
> cube SELECT d.dim1 AS d1, c.attr1 AS m1 from cube as c, dim as d where
> time_range_in(col,'from','to') GROUP BY d.dim1 limit 10
> {CODE}
> Error:-
> {CODE}
> Table 'db.a' doesn't exist cause:null
> {CODE}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
