Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Is it possiable Auto Increment columns in Impala

avatar
Explorer

i need Auto Increment columns in Impala. please let me know this feature is avaliable or not

5 REPLIES 5

avatar

This feature is currrently not available. May I ask what your use case is?

avatar
Explorer

Presently we are using SQL server now we are moving this logic  to one of Big databases   so i am doing POC in Impala. we are doing so many operation based on Auto Increment Column.

 

 So we need AutoIncrement functionality. is there any way to achive this.One more question is Primary column support is there?

avatar

There is no enforcement of key constraints or auto increment in Impala. Please understand that Impala and SQL Server are quite different technologies each with their own unique set of advantades/disadvantages.

 

What kind of operations are you doing based on auto increment?

avatar
Rising Star

whenever a new record is inserted, sequence number has to be generated for key columns.

first day : 100 record with sequence number from 1 to 100.

second day : 10 new records. Sequence number should start from 101 to 110.

 

We can achieve this in ETL tools. Also, In some databases,  we have create sequence function and use the next value in select clause. 

 

Is it possible to achieve in impala ?

avatar
New Contributor

Hello everyone,

 

I was wondering like Iamwan if it was still impossible today (in January 2018) to auto increment an ID (an int, a bigint or whatever) in a table (in Impala or Hive) when data are added. Would you have further information please ?


I didn't find anything about it here : https://www.cloudera.com/documentation/enterprise/5-9-x/topics/impala_datatypes.html


Have a nice day !