Hi, Alex,
Thanks for the reply. After fixing the permission, the query works fine.
Jessica
> On Apr 11, 2015, at 12:58 PM, Alexander Pivovarov
> wrote:
>
> maybe user which runs hive cli does not have write permissions on
> hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db
>
> who is
maybe user which runs hive cli does not have write permissions on
hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db
who is hdfs://zhangj05-a:8020/user/hive/warehouse/reporting.db owner?
what user runs hive cli?
On Sat, Apr 11, 2015 at 11:07 AM, Jie Zhang wrote:
> Hi,
>
> I hit the foll
Hi,
I hit the following error when running a CTAS statment. Looks like a hdfs
permission issue since the temp file can not be renamed. Maybe I miss
setting some property? my hive version is 0.14.0. Any help is appreciated!
hive> create table reporting.test2 as select count(uuid) from store.imr;
Hi,
I have given query , compatible to teradata. It have imported table in
dimension_tab using Sqoop. Tried to execute on HIVE , but unfortunately
compatible to hive.
SELECT fact_1_id,
fact_2_id,
SUM(sales_value) AS sales_value,
*GROUPING(fact_1_id) AS f1g,
GROUPING(f