cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Haim Raman (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-13864) Failure to execute cql script using cqlsh with nested SOURCE on cassandra 3.11.0
Date Wed, 13 Sep 2017 07:05:00 GMT
Haim Raman created CASSANDRA-13864:
--------------------------------------

             Summary: 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. 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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message