[
https://issues.apache.org/jira/browse/CASSANDRA-13864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Haim Raman updated CASSANDRA-13864:
-----------------------------------
Description:
I have a script I used to execute queries and DDL on cassandra 2.1.15 (based on
DSE 4.8.10).
The script include nested use of the SOURCE command.
{code:title=1.sql|borderStyle=solid}
USE test;
SOURCE '2.sql'
exit;
{code}
{code:title=2.sql|borderStyle=solid}
SELECT count(1) FROM user;
SOURCE '3.sql';
{code}
{code:title=3.sql|borderStyle=solid}
SELECT count(1) FROM user;
{code}
When executing this script with DSE 4.8.10 it runs correctly and output
{code:title=cassandra 2.1.15|borderStyle=none}
cqlsh –f 1.sql
count
--------
0
(1 rows)
count
--------
0
(1 rows)
{code}
Running the same script with cassandra 3.11.0 (based on DSE 5.1.2).
{code:title=cassandra 3.11.0|borderStyle=none}
cqlsh –f 1.sql
count
-------
0
(1 rows)
Warnings :
Aggregation query used without partition key
2.sql:3:DSEShell instance has no attribute 'execution_profiles'
{code}
*The actual issue is that the script in 3.sql is not executed.*
I did some additional investigations
# With DSE-5.1.2 I switch the off to authenticator: AllowAllAuthenticator
authorizer: AllowAllAuthorizer, but I am still experiencing the issue
# With DSE-5.0.9 (Cassandra 3.0.13.1735) it works
h4.Steps to reproduce:
Use the attached test.zip
execute
cqlsh -f create_keyspace.sql
cqlsh -f 1.sql
was:
I have a script I used to execute queries and DDL on cassandra 2.1.15 (based on
DSE 4.8.10).
The script include nested use of the SOURCE command. E.g.
1.sql
USE test;
SOURCE '2.sql'
exit;
2.sql
SELECT count(1) FROM user;
SOURCE '3.sql';
3.sql
SELECT count(1) FROM user;
When executing this script with DSE 4.8.10 it runs correctly and output
cqlsh –f 1.sql
count
--------
0
(1 rows)
count
--------
0
(1 rows)
Running the same script with cassandra 3.11.0 (based on DSE 5.1.2).
cqlsh –f 1.sql
count
-------
0
(1 rows)
Warnings :
Aggregation query used without partition key
2.sql:3:DSEShell instance has no attribute 'execution_profiles'
The actual issue is that the script in 3.sql is not executed.
I failed to find any us full information on the error "DSEShell instance has no
attribute 'execution_profiles'"
I failed to figure out what are execution_profiles although they are mentioned
int the python docs here
I did some additional investigations
# With DSE-5.1.2 I switch the off to authenticator: AllowAllAuthenticator
authorizer: AllowAllAuthorizer, but I am still experiencing the issue
# With DSE-5.0.9 (Cassandra 3.0.13.1735) it works
Steps to reproduce:
Use the attached test.zip
execute
cqlsh -f create_keyspace.sql
cqlsh -f 1.sql
> Failure to execute cql script using cqlsh with nested SOURCE on cassandra
> 3.11.0
> ---------------------------------------------------------------------------------
>
> Key: CASSANDRA-13864
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13864
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Environment: SUSE Linux Enterprise Server 12
> Python 2.7.7
> Reporter: Haim Raman
> Attachments: test.zip
>
>
> I have a script I used to execute queries and DDL on cassandra 2.1.15 (based
> on DSE 4.8.10).
> The script include nested use of the SOURCE command.
> {code:title=1.sql|borderStyle=solid}
> USE test;
> SOURCE '2.sql'
> exit;
> {code}
> {code:title=2.sql|borderStyle=solid}
> SELECT count(1) FROM user;
> SOURCE '3.sql';
> {code}
> {code:title=3.sql|borderStyle=solid}
> SELECT count(1) FROM user;
> {code}
> When executing this script with DSE 4.8.10 it runs correctly and output
> {code:title=cassandra 2.1.15|borderStyle=none}
> cqlsh –f 1.sql
> count
> --------
> 0
> (1 rows)
> count
> --------
> 0
> (1 rows)
> {code}
> Running the same script with cassandra 3.11.0 (based on DSE 5.1.2).
> {code:title=cassandra 3.11.0|borderStyle=none}
> cqlsh –f 1.sql
> count
> -------
> 0
> (1 rows)
> Warnings :
> Aggregation query used without partition key
> 2.sql:3:DSEShell instance has no attribute 'execution_profiles'
> {code}
> *The actual issue is that the script in 3.sql is not executed.*
> I did some additional investigations
> # With DSE-5.1.2 I switch the off to authenticator: AllowAllAuthenticator
> authorizer: AllowAllAuthorizer, but I am still experiencing the issue
> # With DSE-5.0.9 (Cassandra 3.0.13.1735) it works
> h4.Steps to reproduce:
> Use the attached test.zip
> execute
> cqlsh -f create_keyspace.sql
> cqlsh -f 1.sql
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
