You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@lens.apache.org by Tao Yan <ty...@linkedin.com> on 2016/08/19 20:40:33 UTC

Support Native HIVE QL

Hi Lens Developer,

I am trying to convert the existing hive queries to Lens cube query and
found it is not possible to convert if the hive query uses UDFs or
hive-only features. So, I wonder if Lens could support native hive queries,
i.e. use can submit hive query in Lens portal, and Lens pass the query to
Hive as it is.

The reason I am asking this is because most companies who may use Lens
should already have many hive queries in production, and if we could first
use Lens to manage all the queries and gradually convert some queries to
Lens QL as Lens QL functionalities enhances, then, probably Lens will be
used to serve most of the query requests, but Lens will still need to
support users' submission of native DB queries at that time since some
features is not part of the SQL standard. The philosophy is very similar to
why Hibernate support standard SQL.

Thanks,
-- 

*Tao Yan*
Software Engineer
Data Analytics Infrastructure Tools and Services



206.250.5345
tyan@linkedin.com
https://www.linkedin.com/in/taousc

Re: Support Native HIVE QL

Posted by Tao Yan <ty...@linkedin.com>.

Thanks!

On Fri, Aug 19, 2016 at 9:42 PM, amareshwarisr . <am...@gmail.com>
wrote:

> Tao,
>
> Native Hive queries should be supported out of the box. Let us know what
> issues you are facing,
>
> Thanks
>
> On Sat, Aug 20, 2016 at 2:10 AM, Tao Yan <ty...@linkedin.com> wrote:
>
>> Hi Lens Developer,
>>
>> I am trying to convert the existing hive queries to Lens cube query and
>> found it is not possible to convert if the hive query uses UDFs or
>> hive-only features. So, I wonder if Lens could support native hive queries,
>> i.e. use can submit hive query in Lens portal, and Lens pass the query to
>> Hive as it is.
>>
>> The reason I am asking this is because most companies who may use Lens
>> should already have many hive queries in production, and if we could first
>> use Lens to manage all the queries and gradually convert some queries to
>> Lens QL as Lens QL functionalities enhances, then, probably Lens will be
>> used to serve most of the query requests, but Lens will still need to
>> support users' submission of native DB queries at that time since some
>> features is not part of the SQL standard. The philosophy is very similar to
>> why Hibernate support standard SQL.
>>
>> 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

Re: Support Native HIVE QL

Posted by "amareshwarisr ." <am...@gmail.com>.

Tao,

Native Hive queries should be supported out of the box. Let us know what
issues you are facing,

Thanks

On Sat, Aug 20, 2016 at 2:10 AM, Tao Yan <ty...@linkedin.com> wrote:

> Hi Lens Developer,
>
> I am trying to convert the existing hive queries to Lens cube query and
> found it is not possible to convert if the hive query uses UDFs or
> hive-only features. So, I wonder if Lens could support native hive queries,
> i.e. use can submit hive query in Lens portal, and Lens pass the query to
> Hive as it is.
>
> The reason I am asking this is because most companies who may use Lens
> should already have many hive queries in production, and if we could first
> use Lens to manage all the queries and gradually convert some queries to
> Lens QL as Lens QL functionalities enhances, then, probably Lens will be
> used to serve most of the query requests, but Lens will still need to
> support users' submission of native DB queries at that time since some
> features is not part of the SQL standard. The philosophy is very similar to
> why Hibernate support standard SQL.
>
> Thanks,
> --
>
> *Tao Yan*
> Software Engineer
> Data Analytics Infrastructure Tools and Services
>
>
>
> 206.250.5345
> tyan@linkedin.com
> https://www.linkedin.com/in/taousc
>