[IGNITE-14109] Calcite integration. Sqlline tool freezes at the authorization step.

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite2-required calcite3-required
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Konstantin Orlov
• Reporter: Fedor Malchikov
• Created: 02/Feb/21 09:18
• Updated: 25/Nov/21 11:30

Description

Although authorization is not even enabled in the config:

Feb 01, 2021 6:44:21 PM org.jline.utils.Log logr
WARNING: Unable to create a system terminal, creating a dumb terminal (enable debug logging for more information)
Setting property: [force, true]
Setting property: [showWarnings, true]
Setting property: [showNestedErrs, true]
issuing: !connect -p driver org.apache.ignite.IgniteJdbcThinDriver "jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true"
Connecting to jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true
Enter username for jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true:

 

If you run the same test but using the 8733 build, then everything is successful:

Setting property: [force, true]
Setting property: [showWarnings, true]
Setting property: [showNestedErrs, true]
issuing: !connect jdbc:ignite:thin://127.0.0.1/?distributedJoins=true '' '' org.apache.ignite.IgniteJdbcThinDriver
Connecting to jdbc:ignite:thin://127.0.0.1/?distributedJoins=true
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.ignite.internal.util.GridUnsafe$2 (file:art-gg-com/libs/ignite-core-8.7.33.jar) to field java.nio.Buffer.address
WARNING: Please consider reporting this to the maintainers of org.apache.ignite.internal.util.GridUnsafe$2
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Connected to: Apache Ignite (version 8.7.33#20201223-sha1:253a2146)
Driver: Apache Ignite Thin JDBC Driver (version 8.7.33#20201223-sha1:253a2146)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
1/436        !outputformat csv

I also tried to enable authorization and connect with options, but tool hangs in the same place:

Feb 01, 2021 6:27:32 PM org.jline.utils.Log logr
WARNING: Unable to create a system terminal, creating a dumb terminal (enable debug logging for more information)
Setting property: [force, true]
Setting property: [showWarnings, true]
Setting property: [showNestedErrs, true]
issuing: !connect -p driver org.apache.ignite.IgniteJdbcThinDriver "jdbc:ignite:thin://127.0.0.1;user=ignite;password=ignite?useExperimentalQueryEngine=true"
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.apache.ignite.internal.util.GridUnsafe$2 (file:/home/prom1se/GG/calcite_work/var/suite-sql_combination/app-ign-calcite/libs/ignite-core-2.9.0.t48.jar) to field java.nio.Buffer.address
WARNING: Please consider reporting this to the maintainers of org.apache.ignite.internal.util.GridUnsafe$2
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
Connecting to jdbc:ignite:thin://127.0.0.1;user=ignite;password=ignite?useExperimentalQueryEngine=true
Enter username for jdbc:ignite:thin://127.0.0.1;user=ignite;password=ignite?useExperimentalQueryEngine=true:

Command line:
['app-ign-calcite/bin/sqlline.sh', '-d', 'org.apache.ignite.IgniteJdbcThinDriver', '--verbose=true', '--force=true', '--showWarnings=true', '--showNestedErrs=true', '-u', 'jdbc:ignite:thin://127.0.0.1?useExperimentalQueryEngine=true', '-f', 'test_sql_combination/ddl_create_with_memory/ddl_create_with_memory..calcite.sql.1.batch.txt']
 

 

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #8745