Is it possible to configure Apache Calcite identifiers to be case insensitive?table not found with apache calciteorg.apache.calcite.sql.validate.SqlValidatorExceptionapache calcite, querying without using the jdbc apiApache Calcite - ReflectiveSchema StackoverflowErrorApache Calcite to Find Selected Columns in an SQL StringWould calcite work on Scala case classesRelbuider on Calcite TablesApache Calcite - How to Integrate CSV and MySQLApache Calcite - Can't seem to parse DDL statementsApache Calcite query json nested data
Which old Technic set included large yellow motor?
Set orthographic view using python?
Is it legal for source code containing undefined behavior to crash the compiler?
Gambler coin problem: fair coin and two-headed coin
Half filled water bottle
What does it take for witness testimony to be believed?
Location of label edges in Tikz Graph
What happened to the HDEV ISS Experiment? Is it over?
Why is a statement like 1 + n *= 3 allowed in Ruby?
about to retire but not retired yet, employed but not working any more
How do I feed my black hole?
Hangman game in Python - need feedback on the quality of code
Why is adding AC power easier than adding DC power?
Breaker Mapping Questions
Why error propagation in CBC mode encryption affect two blocks?
Can you board the plane when your passport is valid less than 3 months?
How do I remap "å" to type "å"?
Did Dr. Hannibal Lecter like Clarice or was he attracted to her?
How do you capitalize agile costs with less mature teams?
How to say "I only speak one which is English." in French?
What are the occurences of total war in the Native Americans?
How many birds in the bush?
Why did my folder names end up like this, and how can I fix this using a script?
How does the OS tell whether an "Address is already in use"?
Is it possible to configure Apache Calcite identifiers to be case insensitive?
table not found with apache calciteorg.apache.calcite.sql.validate.SqlValidatorExceptionapache calcite, querying without using the jdbc apiApache Calcite - ReflectiveSchema StackoverflowErrorApache Calcite to Find Selected Columns in an SQL StringWould calcite work on Scala case classesRelbuider on Calcite TablesApache Calcite - How to Integrate CSV and MySQLApache Calcite - Can't seem to parse DDL statementsApache Calcite query json nested data
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
The Calcite SQL language reference (https://calcite.apache.org/docs/reference.html) says the following:
In Calcite, matching identifiers to the name of the referenced object is case-sensitive. But remember that unquoted identifiers are implicitly converted to upper case before matching, and if the object it refers to was created using an unquoted identifier for its name, then its name will have been converted to upper case also.
Is there some configuration to make both object creation and the query case insensitive? For example, if I have a table named countries is it possible to configure the query validator to accept identifiers either COUNTRIES or countries in the SQL query?
I tried to configure the SqlParser to case sensitive false in the following:
Frameworks.newConfigBuilder().parserConfig(SqlParser.configBuilder().setCaseSensitive(false).build()).build()
and then passed this framework config to the PlannerImpl used in SqlToRelConverter, but the SQL validator still fails when I do not enclose the identifier in quotes to enforce case.
apache-calcite sql-parser
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
add a comment |
The Calcite SQL language reference (https://calcite.apache.org/docs/reference.html) says the following:
In Calcite, matching identifiers to the name of the referenced object is case-sensitive. But remember that unquoted identifiers are implicitly converted to upper case before matching, and if the object it refers to was created using an unquoted identifier for its name, then its name will have been converted to upper case also.
Is there some configuration to make both object creation and the query case insensitive? For example, if I have a table named countries is it possible to configure the query validator to accept identifiers either COUNTRIES or countries in the SQL query?
I tried to configure the SqlParser to case sensitive false in the following:
Frameworks.newConfigBuilder().parserConfig(SqlParser.configBuilder().setCaseSensitive(false).build()).build()
and then passed this framework config to the PlannerImpl used in SqlToRelConverter, but the SQL validator still fails when I do not enclose the identifier in quotes to enforce case.
apache-calcite sql-parser
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
add a comment |
The Calcite SQL language reference (https://calcite.apache.org/docs/reference.html) says the following:
In Calcite, matching identifiers to the name of the referenced object is case-sensitive. But remember that unquoted identifiers are implicitly converted to upper case before matching, and if the object it refers to was created using an unquoted identifier for its name, then its name will have been converted to upper case also.
Is there some configuration to make both object creation and the query case insensitive? For example, if I have a table named countries is it possible to configure the query validator to accept identifiers either COUNTRIES or countries in the SQL query?
I tried to configure the SqlParser to case sensitive false in the following:
Frameworks.newConfigBuilder().parserConfig(SqlParser.configBuilder().setCaseSensitive(false).build()).build()
and then passed this framework config to the PlannerImpl used in SqlToRelConverter, but the SQL validator still fails when I do not enclose the identifier in quotes to enforce case.
apache-calcite sql-parser
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
The Calcite SQL language reference (https://calcite.apache.org/docs/reference.html) says the following:
In Calcite, matching identifiers to the name of the referenced object is case-sensitive. But remember that unquoted identifiers are implicitly converted to upper case before matching, and if the object it refers to was created using an unquoted identifier for its name, then its name will have been converted to upper case also.
Is there some configuration to make both object creation and the query case insensitive? For example, if I have a table named countries is it possible to configure the query validator to accept identifiers either COUNTRIES or countries in the SQL query?
I tried to configure the SqlParser to case sensitive false in the following:
Frameworks.newConfigBuilder().parserConfig(SqlParser.configBuilder().setCaseSensitive(false).build()).build()
and then passed this framework config to the PlannerImpl used in SqlToRelConverter, but the SQL validator still fails when I do not enclose the identifier in quotes to enforce case.
apache-calcite sql-parser
apache-calcite sql-parser
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
asked Mar 27 at 19:58
tuzhuchengtuzhucheng
532 silver badges7 bronze badges
532 silver badges7 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I believe the case sensitivity on the parser is irrelevant here. You'll want to set the case sensitivity on the catalog reader that you're using. For example, if you're using CalciteCatalogReader, you'll want to set CalciteConnectionProperty.CASE_SENSITIVE to true on the CalciteConnectionConfig object you're passing in during configuration.
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55385516%2fis-it-possible-to-configure-apache-calcite-identifiers-to-be-case-insensitive%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I believe the case sensitivity on the parser is irrelevant here. You'll want to set the case sensitivity on the catalog reader that you're using. For example, if you're using CalciteCatalogReader, you'll want to set CalciteConnectionProperty.CASE_SENSITIVE to true on the CalciteConnectionConfig object you're passing in during configuration.
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
add a comment |
I believe the case sensitivity on the parser is irrelevant here. You'll want to set the case sensitivity on the catalog reader that you're using. For example, if you're using CalciteCatalogReader, you'll want to set CalciteConnectionProperty.CASE_SENSITIVE to true on the CalciteConnectionConfig object you're passing in during configuration.
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
add a comment |
I believe the case sensitivity on the parser is irrelevant here. You'll want to set the case sensitivity on the catalog reader that you're using. For example, if you're using CalciteCatalogReader, you'll want to set CalciteConnectionProperty.CASE_SENSITIVE to true on the CalciteConnectionConfig object you're passing in during configuration.
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
I believe the case sensitivity on the parser is irrelevant here. You'll want to set the case sensitivity on the catalog reader that you're using. For example, if you're using CalciteCatalogReader, you'll want to set CalciteConnectionProperty.CASE_SENSITIVE to true on the CalciteConnectionConfig object you're passing in during configuration.
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
answered Mar 28 at 14:45
Michael MiorMichael Mior
22.2k7 gold badges65 silver badges99 bronze badges
22.2k7 gold badges65 silver badges99 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55385516%2fis-it-possible-to-configure-apache-calcite-identifiers-to-be-case-insensitive%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
