Skip to content
#

jdbc

Here are 2,770 public repositories matching this topic...

findepi
findepi commented Sep 6, 2021

With Hive connector

trino:default> CREATE TABLE one (a varchar);
            -> CREATE VIEW two AS SELECT * FROM one;
CREATE TABLE
CREATE VIEW

DROP TABLE is rejected on a view:

trino:default> DROP TABLE two;
Query 20210906_150832_00015_id3y3 failed: line 1:1: Table 'hive.default.two' does not exist, but a view with that name exists. Did you mean DROP VIEW hive.default.t
deusaquilus
deusaquilus commented Oct 26, 2021

The .forall pattern is a great way to create an optional filter for a field that could be defined or not:

case class Person(name: String, age: Int)
val nameOpt: Option[String] = Some("Joe")
run { query[Person].filter(p => lift(nameOpt).forall(_ == p.name)) }
// SELECT p.name, p.age FROM Person p WHERE ? IS NULL OR ? = p.name
// (i.e. when nameOpt := None then the `WHERE ? IS NULL`

Improve this page

Add a description, image, and links to the jdbc topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the jdbc topic, visit your repo's landing page and select "manage topics."

Learn more