Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.
anvanna
Explorer

Re: hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎01-05-2020 07:18 PM
‎01-05-2020 07:18 PM
@Shelton  it seem not help by these configuration because it took me more than 1H  to finish mv rebuild for one day data refresh. other configuration need to customize more?   ... View more

Re: Heterogeneous Storage in HDFS(Part-1)...

by Explorer in Community Articles
‎12-17-2019 08:42 PM
‎12-17-2019 08:42 PM
@mkumar13  how can we move data older than 2 years to ARCHIVE? ... View more

Re: hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎12-17-2019 08:30 PM
‎12-17-2019 08:30 PM
@Shelton  yes still need more help from you Do this setting  SET hive.materializedview.rewriting.time.window=10min;  on  Advanced hive-interactive-site  or  Advance hive-site  ? ... View more

Re: hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎12-15-2019 09:01 PM
‎12-15-2019 09:01 PM
@Shelton  Thank you for your prompted respond Do you execute a Hive query to set the location of the Druid broker using an  address  and  port  of the broker text listening port? No because it is already set via ambari.   Do this setting SET hive.materializedview.rewriting.time.window=10min; on Advanced hive-interactive-site or Advance hive-site ? ... View more

Re: hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎12-13-2019 01:48 AM
‎12-13-2019 01:48 AM
@jitendra03  Could u share  hiveserver2Interactive.log?  Did ur druid historical server installed? ... View more

Re: hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎12-13-2019 01:39 AM
‎12-13-2019 01:39 AM
@Shelton  Thank you very much for a detail solution on compaction Fact Table partition. i have tested and the rebuild mv after compactions and it has change the ways it works before, but i still encountered problem with taking long time on rebuild mv.     ... View more

Re: hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎12-10-2019 06:59 PM
‎12-10-2019 06:59 PM
Do you connect via  -  HIVESERVER2 JDBC URL or HIVESERVER2 INTERACTIVE JDBC URL? ... View more

Re: creating materialized view getting below error...

by Explorer in Support Questions
‎12-02-2019 07:37 PM
‎12-02-2019 07:37 PM
Do you know my hive mv not incremental rebuild with druid storage handler? ... View more

hive druid mv incremental rebuild not work

by Explorer in Support Questions
‎12-02-2019 06:57 PM
‎12-02-2019 06:57 PM
i have using HDP 3.1 and create materialize view with druid handler, but when i try to rebuild this mv, it takes long time to complete. all fact and dimension tables are ACID tables. example DDL as below:     CREATE MATERIALIZED VIEW dwh.druid_fct_txn_sun_mv STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ( 'druid.segment.granularity'='DAY', 'druid.query.granularity'='MINUTE') AS select .....     1. how to verify if this MV is incremental rebuild? 2. how to check writeID on this MV?   ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎07-19-2021 07:24 AM
Public Statistics
Date Registered ‎04-01-2019 04:02 AM
Last Visited ‎07-19-2021 07:24 AM
Total Messages Posted 11