Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is it possiable Auto Increment columns in Impala

Is it possiable Auto Increment columns in Impala

New Contributor

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

5 REPLIES 5

Re: Is it possiable Auto Increment columns in Impala

Master Collaborator

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

Re: Is it possiable Auto Increment columns in Impala

New Contributor

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?

Re: Is it possiable Auto Increment columns in Impala

Master Collaborator

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?

Re: Is it possiable Auto Increment columns in Impala

Explorer

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 ?

Re: Is it possiable Auto Increment columns in Impala

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 !

Don't have an account?
Coming from Hortonworks? Activate your account here