Origin’s Removal of SQL Comments Breaks Apache Drill


Version: 2021

Type: Bug Fixes

Category: Data Handling

Subcategory: Import

Jira: ORG-22153


Origin used to remove comments from SQL statements but that broke Apache Drill. Origin no longer removes comments. But user must be careful to only use comment types supported by their database system.

System variable @SQLC = 0 by default.

To restore to old behavior (remove comments), set it to 1.