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
>

Reply via email to