Hive Schema url Missing


#1

Hi As part of Aruns blog Problem 3, I created a new hive table which is a replica of other table. I want to edit the schema url of the new table i created. I gave the Describe formatted tablename ; but its not displaying the table properties Avro schema url. I tried creating multiple tables, but not able to see the schema table url. Can you please check. Below is the screen shot.

hive (subrudata_arun1)> describe formatted orders_avro1;
OK

col_name data_type comment

order_id int
order_date date
order_customer_id int
order_status string

Partition Information

col_name data_type comment

order_month string

Detailed Table Information

Database: subrudata_arun1
Owner: subrudata
CreateTime: Sat Jul 07 21:00:12 EDT 2018
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://nn01.itversity.com:8020/apps/hive/warehouse/subrudata_arun1.db/orders_avro1
Table Type: MANAGED_TABLE
Table Parameters:
transient_lastDdlTime 1531011612

Storage Information

SerDe Library: org.apache.hadoop.hive.serde2.avro.AvroSerDe
InputFormat: org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
Time taken: 0.07 seconds, Fetched: 34 row(s)
hive (subrudata_arun1)>