Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3147

BigQuery (standard SQL) quoting and identifier issues

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.21.0
    • None
    • None

    Description

      BigQuery escapes single quotes with backticks, and requires triple-quote quoting (like Python) when there is a newline. Also, it does not support the same set of characters in identifiers as other dialects of SQL. For example, it does not support '$'. Ideally, RelToSqlConverter (with the logic of the BigQuery dialect) would handle all this.

       

       

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            swtalbot Steven Talbot
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment