datastax - Failure to execute cql script using cqlsh with nested SOURCE on DSE 5.1.2 -
i have script used execute queries , ddl in dse 4.8.10.
the script include nested use of source command. e.g.
1.sql
use test; source '2.sql' exit;
2.sql
select count(1) user; source '3.sql';
3.sql
select count(1) user;
when executing script dse 4.8.10 runs correctly , output
cqlsh –f 1.sql count -------- 0 (1 rows) count -------- 0 (1 rows)
running same script in 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 script in 3.sql not executed.
failed find useful information on error "dseshell instance has no attribute 'execution_profiles'"
i failed figure out execution_profiles although mentioned int python docs here
note: using python 2.7.7
update did additional investigations
- with dse-5.1.2 switch off authenticator: allowallauthenticator authorizer: allowallauthorizer, still experiencing issue
with dse-5.1.1 happens
with dse-5.0.9 works
- i failed reproduce in apache cassandra 3.11.0
Comments
Post a Comment