[
https://issues.apache.org/jira/browse/SPARK-15848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15891180#comment-15891180
]
Dongjoon Hyun commented on SPARK-15848:
---------------------------------------
Hi, [~pratik.shah2462].
It doesn't happen in Spark 2.1.
For Spark 1.6.3, I can do the following.
{code}
spark-sql> ALTER TABLE avro_table_uppercase SET TBLPROPERTIES
('avro.schema.literal'='{"namespace": "com.rishav.avro", "name":
"student_marks", "type": "record", "fields": [ {
"name":"student_id","aliases":["STUDENT_ID"],"type":"int"}, {
"name":"subject_id","aliases":["SUBJECT_ID"],"type":"int"}, {
"name":"marks","type":"int"}]}');
spark-sql> select * from avro_table_uppercase;
5 300 100 2000
7 650 20 2000
8 780 160 2000
1 340 963 2000
9 780 142 2000
2 110 430 2000
0 38 91 2002
0 65 28 2002
0 78 16 2002
1 34 96 2002
1 78 14 2002
1 11 43 2002
Time taken: 0.241 seconds, Fetched 12 row(s)
{code}
> Spark unable to read partitioned table in avro format and column name in
> upper case
> -----------------------------------------------------------------------------------
>
> Key: SPARK-15848
> URL: https://issues.apache.org/jira/browse/SPARK-15848
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.6.1
> Reporter: Zhan Zhang
>
> If external partitioned Hive tables created in Avro format.
> Spark is returning "null" values if columns names are in Uppercase in the
> Avro schema.
> The same tables return proper data when queried in the Hive client.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
