Create & Drop INDEX in Cassandra- Shikshaglobe

Content Creator: Satish kumar

Cassandra Create Index

Order 'Make file' makes a record on the segment determined by the client. Assuming the information as of now exists for the segment you need to file, Cassandra makes records on the information during the 'make list' proclamation execution.In the wake of making a list, Cassandra records new information consequently when information is embedded.The list can't be made on essential key as an essential key is as of now filed.Lists on assortments are not upheld in Cassandra.Without ordering on the section, Cassandra can't channel that segment except if it is an essential key.That is the reason, for sifting sections in Cassandra, records should be made.Here is the preview where it was attempted to channel "dept" section without making the record. Accordingly, the mistake was returned.

Here is the preview where list is made on dept section.

Make file DeptIndex on University.Student(dept);Here is the depiction where it will be effectively sifted 'dept' segment.

Cassandra Drop Index

Order 'Drop list' drops the predetermined file. In the event that record name was not given during file creation, then, at that point, list name is TableName_ColumnName_idx.

There is no such thing as on the off chance that the list, it will return a mistake except IF EXISTS is utilized that will return no-operation.

During list creation, you need to determine keyspace name with the file name any other way record will be dropped from the current keyspace.

Drop file IF EXISTS KeyspaceName.IndexName

Here is the depiction of the executed order 'Drop record' that drops the list DeptIndex.

drop file IF EXISTS University.DeptIndex;

After effective execution of the order, DeptIndex will be dropped from the keyspace. Presently information can't be separated by the segment dept.

Implant Data

The Cassandra implant verbalization creates data in Cassandra areas in line structure. Cassandra implant request will store simply those segments that are given by the client. You really want to on a very basic level decide just the fundamental key segment.It won't take any space for not given values. No results are returned after expansion.Here is the see of the executed Cassandra Insert into table inquiry that will implant one record in Cassandra table 'Student'.

Implant into request in Cassandra Query Language

Implant into University.Student(RollNo,Name,dept,Semester) values(2,'Michael','CS', 2);After successful execution of the request Insert into Cassandra, one section will be implanted in the Cassandra table Student with RollNo 2, Name Michael, dept CS and Semester 2.Here is the review of the continuous informational collection state.Cassandra does upsert. Upsert suggests that Cassandra will implant a line if a fundamental key exists as of now for no situation expecting fundamental key at this point exists, it will revive that section.

Update Data

The Cassandra Update question is used to revive the data in the Cassandra table. If no results are returned directly following invigorating data, it suggests data is successfully revived in the event that not a botch will be returned. Segment values are changed in 'Set' arrangement while data is filtered with 'Where' articulation.After powerful execution of the update question in Cassandra 'Update Student', student name will be changed from 'Clark' to 'Hayden' that has rollnoHere is the screen catch that shows the data base state ensuing to reviving data.Outline of Update request in Cassandra Query LanguageCassandra Delete DataRequest 'Eradicate' wipes out an entire line or a couple of segments from the table Student. Exactly when data is deleted, it isn't eradicated from the table immediately. Maybe deleted data is separate with a headstone and are wiped out after compaction.



Click Here For More Detail:

Download & Install HIVE 
HIVE Metastore Configuration 
Hive Data Types 

Featured Universities

Mahatma Gandhi University

Location: Soreng ,Sikkim , India
Approved: UGC
Course Offered: UG and PG

MATS University

Location: Raipur, Chhattisgarh, India
Approved: UGC
Course Offered: UG and PG

Kalinga University

Location: Raipur, Chhattisgarh,India
Approved: UGC
Course Offered: UG and PG

Vinayaka Missions Sikkim University

Location: Gangtok, Sikkim, India
Approved: UGC
Course Offered: UG and PG

Sabarmati University

Location: Ahmedabad, Gujarat, India
Approved: UGC
Course Offered: UG and PG

Arni University

Location: Tanda, Himachal Pradesh, India.
Approved: UGC
Course Offered: UG and PG

Capital University

Location: Jhumri Telaiya Jharkhand,India
Approved: UGC
Course Offered: UG and PG

Glocal University

Location: Saharanpur, UP, India.
Approved: UGC
Course Offered: UG and PG

Himalayan Garhwal University

Location: PG, Uttarakhand, India
Approved: UGC
Course Offered: UG and PG

Sikkim Professional University

Location: Sikkim, India
Approved: UGC
Course Offered: UG and PG

North East Frontier Technical University

Location: Aalo, AP ,India
Approved: UGC
Course Offered: UG and PG