[
https://issues.apache.org/jira/browse/CALCITE-5389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17640984#comment-17640984
]
Oliver Lee commented on CALCITE-5389:
-------------------------------------
[~julianhyde] ,
I've tried a series of queries but so far it's been impossible to get any
{{BYTES}} or {{VARBINARY}} value in BigQuery dialect
- {{SELECT SUBSTRING("12345", 2)}} -> ✅ this is OK, just to confirm
{{SUBSTRING}} works
- {{SELECT SUBSTRING(b'12345', 2)}} -> {{ParseException: Encountered
"\'12345\'"}}
- {{SELECT SUBSTRING(b"12345", 2)}} -> {{ParseException: Encountered
"\'12345\'"}}
-{{{}SELECT CAST("12345" AS VARBINARY){}}} ->
{quote}Error: Error while executing SQL "SELECT CAST("12345" as VARBINARY)":
com.fasterxml.jackson.core.JsonParseException: Unexpected character ('<' (code
60)): expected a valid value (JSON String, Number, Array, Object or token
'null', 'true' or 'false')
at [Source: (String)"<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 java.lang.AssertionError: value 12345 does not match type
class org.apache.calcite.avatica.util.ByteString</title>
{quote}
- {{SELECT CAST("12345" as BYTES)}} -> {{SqlValidatorException: Unknown
identifier 'BYTES'}}
Could I close this current ticket to just enable {{STARTS_WITH}} for {{STRING}}
and have {{BYTES}} be a followup?
> STARTS_WITH for BIG_QUERY
> -------------------------
>
> Key: CALCITE-5389
> URL: https://issues.apache.org/jira/browse/CALCITE-5389
> Project: Calcite
> Issue Type: Improvement
> Reporter: Oliver Lee
> Assignee: Oliver Lee
> Priority: Trivial
> Labels: pull-request-available
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> Adding support for STARTS_WITH for BIG_QUERY dialect
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
