Lingual - Sub Query Support

[Bhushan Pargaonkar]

Hi Chris,

I have worked on a POC for trying Cascading and liked the ease of big data processing application development cascading offers.

I am recommending it to my customer along with Lingual integration. Lingual looks promising to me but could not get much examples on same. 

I have following questions on Lingual advance query support.

1. Can we have sub query in where clause of Lingual query?

2. Can we have correlated sub query in Lingual; wherein we use left had side table fields within sub-query.?

It would be a lot of help if you can direct me to good examples of various queries and limitations of Lingual as on today for better understandings of offerings.

Thanks & Regards,

Bhushan

[Andre Kelpe]

On Sun, Feb 21, 2016 at 2:06 PM, Bhushan Pargaonkar
<bhushan.p...@gmail.com> wrote:
> Hi Chris,
>
> I have worked on a POC for trying Cascading and liked the ease of big data
> processing application development cascading offers.
> I am recommending it to my customer along with Lingual integration.

Great!

> Lingual
> looks promising to me but could not get much examples on same.
> I have following questions on Lingual advance query support.
>
> 1. Can we have sub query in where clause of Lingual query?
> 2. Can we have correlated sub query in Lingual; wherein we use left had side
> table fields within sub-query.?

sub-queries are supported. Did you see the user guide?
http://docs.concurrentinc.com/lingual/2.0/index.html

> It would be a lot of help if you can direct me to good examples of various
> queries and limitations of Lingual as on today for better understandings of
> offerings.

see here: http://docs.concurrentinc.com/lingual/2.0/index.html#sql-support

- André

>
> Thanks & Regards,
> Bhushan
>
> --
> You received this message because you are subscribed to the Google Groups
> "cascading-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cascading-use...@googlegroups.com.
> To post to this group, send email to cascadi...@googlegroups.com.
> Visit this group at https://groups.google.com/group/cascading-user.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/cascading-user/a322493f-7eb9-4a35-8dd0-1faf43d0e70f%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
André Kelpe
an...@concurrentinc.com
http://concurrentinc.com

[Bhushan Pargaonkar]

Thanks Andre for your reply and help.

I found best place to get help from Junits you guys have developed. I think that is good place to look at for Lingual supported and WIP features in terms of query support including links you shared.

https://github.com/Cascading/lingual/blob/wip-2.0/lingual-platform/src/test/java/cascading/lingual/jdbc/SimpleSqlPlatformTest.java

Thanks