Load Parquet and Json file into trafodion table

2017-06-15 Thread Wang, Ai-Min (Benny)
Hi all: Does trafodion support Parquet and Json file? For Parquet file, we can load it into Hive text file , then reload into trafodion table. Any best idea for load data from Parquet? How about load Json file into trafodion table? Best Regrard! Benny/Wang Aimin MP:13501196050

alter table add constraint ? modify constraint?

2017-06-15 Thread Eric Owhadi
Hi Trafodioneers, Looking at the doc, I don't see that there is syntax to modify a constraint. Should I assume that the only way to modify a constraint is to drop it first then add it back? Are these drop constraint, add constraint transactionaly protected? Thanks in advance for the help, Eric