Member since
04-01-2019
11
Posts
0
Kudos Received
0
Solutions
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
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
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
12-13-2019
01:48 AM
@jitendra03 Could u share hiveserver2Interactive.log? Did ur druid historical server installed?
... View more
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
12-10-2019
06:59 PM
Do you connect via - HIVESERVER2 JDBC URL or HIVESERVER2 INTERACTIVE JDBC URL?
... View more
12-02-2019
07:37 PM
Do you know my hive mv not incremental rebuild with druid storage handler?
... View more
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: