Question related to handling of nulls in csv

Hi, I am trying to understand the behavior while handling nulls. I have a csv file where the last column is integer values and has nulls for few rows. When I run an aggregation function like sum on that column I am getting UNSUPPORTED_OPERATION ERROR. Any pointers or links would be great. Thanks

Question related to escaping in create table as for CSV

*Input csv (filename: input.csv):* "Id","customer_id__c","first_name__c","last_name__c","email__c","address__c","city__c","state__c","zipcode__c","careOf__c" "a1T41004uG6EAI",1.0,"George","Washington","gwashing...@usa.gov","3200 Mt Vernon Hwy","Mount Vernon","VA",22121.0,"!@Satya__ , ()" *c

Re: Question related to escaping in create table as for CSV

Hi, Please let me know if there is any setting or workaround for this. - Thanks, Sandeep > On Aug 29, 2016, at 6:18 PM, Sandeep Dugar wrote: > > Input csv (filename: input.csv): > > "Id","customer_id__c","first_name__c","last_name__c",&

UDF IndexOutOfBoundsException for large String

Hi , I am trying to write a UDF for which the input is text, possibly with 1K characters. I am trying to get the string value from NullableVarcharHolder via the function org.apache.drill.exec.expr.fn.impl.StringFunctionHelpers.toStringFromUTF8(input.start, input.end, input.buffer); This is re

Drill UDF input - pass variable list of strings

Hi, I am trying to write a UDF which will whether a list of strings is contained in another list. Is there a way to pass a list of values to UDF where the list size is variable? Thanks in advance! - Regards, Sandeep