spline-spark-agent icon indicating copy to clipboard operation
spline-spark-agent copied to clipboard

JDBC dbtable query option support

Open DaimonPl opened this issue 4 years ago • 2 comments

That's tricky one :) I've found one case where JDBC datasoruce is used for reading with dbtable option, where dbtable is a query :)

here's example what spline reports in such situation

jdbc:mysql://host.net:3336/my_database?serverTimezone=Poland&useSSL=false&characterEncoding=utf8:( SELECT *\n  FROM some_table\n  WHERE x_date = CAST('2020-06-14' AS DATE)\n    AND y IN (SELECT y FROM other_table)\n    AND y BETWEEN 26409 AND 675433\n) tmp

It probably would be very difficult but ideally 2 lineage sources some_table and other_table could be reported here

DaimonPl avatar Jun 18 '20 08:06 DaimonPl