Reply
New Contributor
Posts: 7
Registered: ‎06-29-2015

Is it possiable Auto Increment columns in Impala

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

Cloudera Employee
Posts: 307
Registered: ‎10-16-2013

Re: Is it possiable Auto Increment columns in Impala

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

New Contributor
Posts: 7
Registered: ‎06-29-2015

Re: Is it possiable Auto Increment columns in Impala

[ Edited ]

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?

Cloudera Employee
Posts: 307
Registered: ‎10-16-2013

Re: Is it possiable Auto Increment columns in Impala

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?

Explorer
Posts: 13
Registered: ‎02-29-2016

Re: Is it possiable Auto Increment columns in Impala

[ Edited ]

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 ?

New Contributor
Posts: 2
Registered: ‎12-10-2017

Re: Is it possiable Auto Increment columns in Impala

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 !

Announcements