Yes, when you described the avro table, what you get back was actually from your avro schema instead of database table. The avro table is NOT considered as a metastore backed SerDe. But that it has its columns populated to DB (e.g. HIVE-6308 <https://issues.apache.org/jira/browse/HIVE-6308>) is mainly for column statistics purpose, which obviously is not applicable to your case which has a type name > 100kb.
Chaoyu On Mon, Sep 28, 2015 at 8:12 PM, Sergey Shelukhin <ser...@hortonworks.com> wrote: > Hi. > I noticed that when I create an Avro table using a very large schema file, > mysql metastore silently truncates the TYPE_NAME in COLUMNS_V2 table to > the size of varchar (4000); however, when I do describe on the table, it > still displays the whole type name (around 100Kb long) that I presume it > gets from deserializer. > Is the value in TYPE_NAME used for anything for Avro tables? > >