CODAIT / spark-netezza

Netezza Connector for Apache Spark
Apache License 2.0
13 stars 7 forks source link

Bug: mixed lowercase/ uppercase column name #2

Open lynochka opened 8 years ago

lynochka commented 8 years ago

-------- Forwarded Message -------- Subject: Re: Spark non-capital table names Date: Thu, 17 Mar 2016 00:44:07 -0700 From: Suresh Thalamati suresh.thalamati@gmail.com To: Luciano Resende luckbr1975@gmail.com CC: Alina Astrakova alina.astrakova@iknowsolutions.eu, Suresht@apache.org

Hi Alina, Thank you for trying out the netezza connector. By looking at the errors “YEAR” attribute not found. I took a quick look at the code , the column names are not getting quoted in the connector. Mixed case column names are getting treated as uppercase by Netezza , and resulting in error.

I am afraid you are running into a bug , can you please open a defect. https://github.com/SparkTC/spark-netezza/issues

Thanks -suresh

screenshot from 2016-03-15 17-35-54 screenshot from 2016-03-15 17-36-17 screenshot from 2016-03-15 17-36-50