How to bulk load a csv file into a phoenix table created in lowercase

2020-05-11 Thread Mich Talebzadeh
Hi, I have a phoenix table *created in lowercase *as follows: CREATE TABLE "MICHTEST"."StagingNotificationPreferencesRT" ( ROWKEY VARCHAR NOT NULL PRIMARY KEY , "cf"."partyId" VARCHAR , "cf"."childNotificationId" VARCHAR , "cf"."brand" VARCHAR , "cf"."accountReference" VARCHAR ,

Advice on primary row key construction

2020-05-11 Thread Simon Mottram
Hiya, hope someone has some tips to spare on this subject I have a use case where a column is an array and we would like to be able to filter records based on this array. We know that the number of elements in the array would be small, 10 absolute max. Is there a way we can encode this in a