CODEWITHSUNDEEP
sqlselectcassandracassandra-2.0cql
Aamir
Aamir

Reputation: 2283

SELECT query in cassandra

I'm getting error "line 2:28 no viable alternative at input 'api_version As ApiVersion" In cassandra. I'm new to cassandra. My query is.

    "SELECT 'api_version As ApiVersion',
            'sid As CarrierSid',
            'phone_number As PhoneNumber',
            'network As Network',
            'wireless As Wireless',
            'zipCode As ZipCode',
            'city As City',
            'price As Price',
            'date_time As CreatedDate', 
            FROM carrier";

Upvotes: 2

Views: 558

Answers (1)

undefined_variable
undefined_variable

Reputation: 6218

 "SELECT api_version As ApiVersion,
            sid As CarrierSid,
            phone_number As PhoneNumber,
            network As Network,
            wireless As Wireless,
            zipCode As ZipCode,
            city As City,
            price As Price,
            date_time As CreatedDate, 
            FROM carrier";

You have single quotes (') which is making query to fail. Try without it.

Upvotes: 1

Related Questions