[SPARK-3393] [SQL] add configuration template for HQL users

User may be confused for the HQL logging & configurations, we'd better provide a default templates.

Both files are copied from Hive.
The license header is not exactly the same as other files, I'm not sure but maybe RAT may reject this one.