CODEWITHSUNDEEP
cassandracqlcqlsh
Anurag Chaudhary
Anurag Chaudhary

Reputation: 71

InvalidRequest: code=2200 [Invalid query] message="Unknown identifier emp_id"

I have created the keyspace and created the table inside it emp, its giving me error while inserting values, have I missed anything?

cqlsh> create keyspace dev WITH replication = {'class': 'SimpleStrategy','replication_factor':1}; cqlsh> use dev ... ; cqlsh:dev> create table emp(empid int primary key,emp_first varchar,emp_last varchar,emp_dept varchar); cqlsh:dev> select * from emp

cqlsh:dev> insert into emp(emp_id,emp_first,emp_last,emp_dept) values(1,'fred','smith','eng'); InvalidRequest: code=2200 [Invalid query] message="Unknown identifier emp_id"

Upvotes: 0

Views: 3514

Answers (1)

MarcintheCloud
MarcintheCloud

Reputation: 1653

In your CREATE TABLE statement, you called it empid

In your INSERT statement, you called it emp_id.

Simply change emp_id in your INSERT statement to empid

INSERT INTO dev.emp (empid,emp_first,emp_last,emp_dept) values(1,'fred','smith','eng');

Upvotes: 4

Related Questions