Can we execute sql query on table saw Table?

[kknandagiri]

I was looking for a feature, if we could execute a sql query something similar to Spark sql kinda functionality with tablesaw.

[lwhite1]

Not exactly, but you can do most SQL kinds of statements in a single statement, with the exception of Having clauses: they would take two statements. For example, to execute something similar to a SQL LIKE with sorted results, you could do: ``` t.where(t.stringColumn("foo").startsWith("bar")) .sortOn("age"); ``` There are also options for joins, and aggregation with/without grouping, but the model for Tablesaw was data frames rather than SQL.

…

On Thu, Sep 2, 2021 at 5:49 AM kknandagiri ***@***.***> wrote: I was looking for a feature, if we could execute a sql query something similar to Spark sql kinda functionality with tablesaw. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#988>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA2FPAUQH7IJHDXDUKB5UOLT75CDDANCNFSM5DIVZFOQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.