a difference in behaviour between SOURCE command in CQLSH 3.1 and 3.2.
In CQLSH 3.1 SOURCE will NOT require "use keyspace" in the cql file that you execute: the "keyspace" directive in the qlshrc file will work and the cql file will be executed.
In CQLSH 3.2.1, SOURCE command requires that "use keyspace" is in the cql file that you are sourcing, otherwise it throws this error:
"No keyspace has been specified. USE a keyspace, or explicitly specify keyspace.tablename".
The "keyspace" directive in cqlshrc is overridden by source command.
steps to reproduce:
create a file called select.cql in your home directory:
Add this to cqlsgrc:
Then exit cqlsh and rerun cqlsh using the cqlshrc just modified.
Note that you are in keyspace "kspace".
this will have different behaviour in CQLSH 3.2 and 3.1