This problem has been solved by following @liuming's advice.
Just follow the steps:
     install Hive,
     'sqstop',
     'sqgen',
     'sqstart'.
then you have hive in Trafodion.

乔彦克 <qyanke@gmail.com>于2016年9月5日周一 下午2:25写道：

> Hi, all:
>     I installed Trafodion without configuring hive, now I want to use Hive
> and do some bulk load and create index table.
>     Can anyone tell me how to config this, or do I need reinstall
> trafodion?
>
> Any reply is appreciated.
> Thanks
> Qiao
>