lens-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajat Khandelwal <rajatgupt...@gmail.com>
Subject Re: Difference between Select and Cube Select
Date Wed, 24 Aug 2016 07:00:18 GMT
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 <tyan@linkedin.com> 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 . <amareshwari@gmail.com>
> 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 <tyan@linkedin.com> 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
>>> tyan@linkedin.com
>>> https://www.linkedin.com/in/taousc
>>>
>>
>>
>
>
> --
>
> *Tao Yan*
> Software Engineer
> Data Analytics Infrastructure Tools and Services
>
>
>
> 206.250.5345
> tyan@linkedin.com
> https://www.linkedin.com/in/taousc
>

Mime
View raw message