Cloudera Community
flashacid
user rank
Explorer

Re: HDP 3 Hive: create view if not exists fails

by Explorer in Support Questions
‎08-25-2018 09:18 AM
‎08-25-2018 09:18 AM
Thanks, issue created: https://issues.apache.org/jira/browse/HIVE-20462 ... View more

Re: HDP 3 Hive: create view if not exists fails

by Explorer in Support Questions
‎08-24-2018 03:01 PM
‎08-24-2018 03:01 PM
Hi Geofffrey, yes the view already exists, but "if not exists" should suppress the error, no matter if which database I'm on. This works fine in HDP 2.6 (Hive 1.2) but does not work in HDP 3.0 (Hive 3.1.0.3.0.0.0-1634) anymore. If I create a new database "max", your example will fail the second time I call "create view if not exists test20 as select 1;" ... View more

HDP 3 Hive: create view if not exists fails

by Explorer in Support Questions
‎08-24-2018 11:46 AM
‎08-24-2018 11:46 AM
After upgrading to HDP 3.0, I can't run my queries anymore. It seems that "if not exists" is ignored in "create view". Example: create view if not exists test as select 1; create view if not exists test as select 1; The second call will fail with: INFO : Starting task [Stage-1:DDL] in serial mode ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Table already exists: default.test INFO : Completed executing command(queryId=hive_20180824114455_907fb7eb-d05a-4831-8482-4f0f3d761721); Time taken: 0.031 seconds Restarting hiveserver2 and beeline does not help. Does anybody else has this problem? ... View more

TEZ-UI (self hosted) not showing any jobs in HDP 3...

by Explorer in Support Questions
‎08-24-2018 10:46 AM
‎08-24-2018 10:46 AM
As TEZ view is removed in Ambari 2.7, I downloaded and hosted the tez-ui myself. I did setup timeline and resource manager addresses in configs.env, however no job is shown in tez-ui: "No records available" A call to http://server:8188/ws/v1/timeline/TEZ_DAG_ID?limit=10 returns empty result: {"entities":[]} Browsing the timeline server (http://server:8188) shows my TEZ jobs. So I think my tez jobs are correctly sent to timeline server. When comparing the recommended settings from https://tez.apache.org/tez-ui.html I see following differences tez.history.logging.service.class Ambari: org.apache.hadoop.yarn.server.timeline.EntityGroupFSTimelineStore tez-ui.html: org.apache.tez.dag.history.logging.ats.ATSHistoryLoggingService All settings in Ambari 2.7 for the whole cluster are default values. Any idea? How can I let the timeline webservice show my jobs? ... View more

Where is TEZ UI/View in Ambari 2.7?

by Explorer in Support Questions
‎08-23-2018 08:28 AM
‎08-23-2018 08:28 AM
After upgrading to Ambari 2.7 we're missing the TEZ UI. We used it a lot to debug and view Hive queries. Where is it and how can I bring it back? Thanks a lot. ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎08-27-2018 11:27 AM
Community Statistics
Member Since ‎08-23-2018 08:26 AM
Last Visited ‎08-27-2018 11:27 AM
Posts 5