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?
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?
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 ?
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 !