1

I'm trying to do a select with cql in which I want a new column to be added to the results with its cells set to some specific value, as it is done in sql in the following question: Relevant question

SELECT
  hat,
  shoe,
  boat,
  0 as placeholder
FROM
  objects

Is this possible? Thanks for your help!

Community
  • 1
  • 1
  • 1
    NO.. this is not possible in cassandra – undefined_variable May 17 '17 at 10:17
  • Damn.. it would be a nice feature to have. Thanks! –  May 17 '17 at 10:56
  • [Here's](https://issues.apache.org/jira/browse/CASSANDRA-11935) a proposal for adding arithmetic operations in CQL. It's not clear to me if we'll be able to write numbers directly in CQL or if the patch allows two columns to be summed. This feature will come out with Cassandra 4.0 – xmas79 May 17 '17 at 13:37

0 Answers0