Standard file extension for hive ddl script?

Question

Is there an accepted convention for a file extension for a hive ddl script? I am purely asking for code organization purpose, so that when I save the script in my repository it is obvious the script is in Hive.

Answer 1

The standard at Apache Hive project is to use .q

You can see examples here

Apache SVN

hive/trunk/ql/src/test/queries/clientpositive/bucketmapjoin6.q

Answer 2

you can use any extension to run hive scripts. for example

hive -f scriptname.sh

but using .hql is is the best practice so that you can differentiate this file from other files.