I am getting STDDEV and trying to insert output to a table.
However output is coming as NaN for one row causing bulk load to fail. Is NaN defined so that we can limit the value ?

Hi, Check out the documentation for "Copying Data" and see if it helps It explains how to copy tables that have identity columns. https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/AdministratorsGuide/CopyExportData/CopyingData.htm Thanks Jim, I don't have connectivity set up between server...

How to migrate tables having identity columns and keep the number same across both servers?

i was trying to create cube with data requiring count of distinct values of two columns . but getting error [Vertica][VJDBC](6549) ERROR: DISTINCT Aggregates are not allowed with MultiLevel Aggregates . Is there any workaround or extension like this. SELECT REQUEST_ID, MEMBER_GENDER, MEMBER_RISK_SCO...