[SPARK-25883] Override method `prettyName` in `from_avro`/`to_avro`

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 2.4.1, 3.0.0
• Component/s: SQL
• Assignee: Gengliang Wang
• Reporter: Gengliang Wang
• Created: 30/Oct/18 09:38
• Updated: 16/Nov/18 03:11
• Resolved: 31/Oct/18 07:00

Description

Previously in from_avro/to_avro, we override the method `simpleString` and `sql` for the string output. However, the override only affects the alias naming:
```
Project [from_avro('col,
...
, (mode,PERMISSIVE)) AS from_avro(col, struct<col1:bigint,col2:double>, Map(mode -> PERMISSIVE))#11]
```
It only makes the alias name quite long.

We should follow `from_csv`/`from_json` here, to override the method prettyName only, and we will get a clean alias name

```
... AS from_avro(col)#11
```

Issue Links

• is duplicated by: SPARK-26063 CatalystDataToAvro gives "UnresolvedException: Invalid call to dataType on unresolved object" when requested for numberedTreeString
• links to: [Github] Pull Request #22890 (gengliangwang)
• links to: [Github] Pull Request #23047 (gengliangwang)