It looks like tickets has been opened for this but the fix isn't working..
https://jira.apache.org/jira/browse/DRILL-5983 Unsupported nullable converted type INT_8 for primitive type INT32 error https://jira.apache.org/jira/browse/DRILL-4764 Parquet file with INT_16, etc. logical types not supported by simple SELECT -----Original Message----- From: Lee, David Sent: Monday, June 18, 2018 6:16 AM To: [email protected] Subject: Problem wit nulls in parquet file for int_16 in parquet Here's the list of all the datatypes for Parquet file metadata.. https://github.com/apache/parquet-format/blob/master/LogicalTypes.md I recently started using PyArrow to generate parquet files and it looks like Drill can't convert a primitive INT32 in the file to a logical INT_16 if it is NULL.. Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: ExecutionSetupException: Unsupported nullable converted type INT_16 for primitive type INT32 Fragment 1:3 This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information. Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy. For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations. © 2018 BlackRock, Inc. All rights reserved.
