If the query is executed in multiple drivers, and more than one drivers return the result, then, how does Lens decide which result to return to user? And if one driver return result before others, will Lens wait for other drivers?
Thanks, On Wed, Aug 24, 2016 at 12:00 AM, Rajat Khandelwal <[email protected]> wrote: > 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 >> > -- *Tao Yan* Software Engineer Data Analytics Infrastructure Tools and Services 206.250.5345 [email protected] https://www.linkedin.com/in/taousc
