marcothesane
Administrator
-
Re: Pivot with non unique IDs
The query should be this: SELECT id, (MAX(CASE fruit WHEN 'Pear' THEN counter END) IS NOT NULL) AS Pear, (MAX(CASE fruit WHEN 'Orange' THEN counter END) IS NOT NULL) AS Orange, (M… (View Post)1 -
Re: How to read first element from an arraylist which is stored as varchar
Does this server your purpose? WITH indata(s) AS ( SELECT '[''Baby Unisex'', ''Baby'']'UNION ALL SELECT '[''Pre-Owned'']… (View Post)1 -
Re: Vertica Collation Problem
The error message is not very informative. I would also blame SAP Data Service for not retrieving the error message from the ODBC/JDBC driver. What is the codepage in MS SQL? UTF-8 -> you should n… (View Post)1 -
Re: Vertica Collation Problem
Take a French first name as an example. 'Jérôme' is 6 characters long. CHARACTER_LENGTH('Jérôme') will accordingly return 6. OCTET_LENGTH('Jérôme'), in Vertica, however,… (View Post)1 -
Re: How to INSERT INTO with SELECT and default values
Just specify the columns into which you actually want to insert something: INSERT INTO the_table( c)SELECT cFROM whatever; (View Post)1
