Yes, it can be any standard sql. The logic in lens is to check the from clause, and if the entity in the from-clause is either a cube or a dimension, then treat it as cube query, and do the translation before running this query. If it's not a cube or a dimension, it's treated as a native query and all the drivers are forwarded this query as it is without any translation.
On Wed, Aug 24, 2016 at 5:43 AM Tao Yan <[email protected]> wrote: > When using "select" (not "cube select"), can it be any standard SQL (not > bounded to Lens QL)? > > Thanks! > > On Tue, Aug 23, 2016 at 4:57 PM, amareshwarisr . <[email protected]> > wrote: > >> cube select expects the from clause to be on cube/dimension. select is >> the one in SQL. >> >> Going forward from 2.6 onwards, cube keyword is optional for >> cube/dimension queries. >> >> Thanks >> >> On Wed, Aug 24, 2016 at 3:53 AM, Tao Yan <[email protected]> wrote: >> >>> Hi Lens Developer, >>> >>> I found the following example in >>> https://github.com/apache/lens/blob/master/lens-examples/src/main/resources/dimension-queries.sql >>> >>> select * from (cube select sample_dim.name name1, sample_dim2_chain.name >>> name2 from sample_dim where sample_dim.name !='first') a >>> >>> I tested "cube select * " and it didn't work, and the above example >>> shows "select *". What is the difference between "select" and "cube select"? >>> >>> Thanks, >>> -- >>> >>> *Tao Yan* >>> Software Engineer >>> Data Analytics Infrastructure Tools and Services >>> >>> >>> >>> 206.250.5345 >>> [email protected] >>> https://www.linkedin.com/in/taousc >>> >> >> > > > -- > > *Tao Yan* > Software Engineer > Data Analytics Infrastructure Tools and Services > > > > 206.250.5345 > [email protected] > https://www.linkedin.com/in/taousc >
