lens-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tao Yan <t...@linkedin.com>
Subject Re: Difference between Select and Cube Select
Date Wed, 24 Aug 2016 00:13:20 GMT
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/l
>> ens/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