Hi:
Check LOG4J log file (Usaually, it is in /tmp/hive/hive.log or
/tmp/${LOGNAME}/hive.log) for more details on the reason for the failure to
instantiate HiveMetaStore client.
If the MySQLConnection was stale due to long pause, try adding
'autoReconnect=true' option to the MySQL url
>
If it is not so much data, you can use Excel's PivotTable to solve this specific requirement:1. Select the date and plz columns (w/o header) and create pivotTable on a new WorkSheet2. Drag the column name: 'Date' from the 'Pivot Table' Builder to the 'Column Label' section.3. Drag the column name:
