THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Note that for versions of Hive which don't include HIVE-287, you'll need to use COUNT(1) in place of COUNT.
...
Note that for versions of Hive which don't include HIVE-287, you'll need to use COUNT(1) in place of COUNT.