Member since
10-08-2018
3
Posts
0
Kudos Received
0
Solutions
04-01-2019
11:23 AM
Hi Team, I am getting below error while running simple update statement also NTP frequently crashing. Query: UPDATE T_GOLDEN_ID_MASTER SET T_GOLDEN_ID_MASTER.GID = T_GOLDEN_PAIRS.GID FROM T_GOLDEN_ID_MASTER INNER JOIN T_GOLDEN_PAIRS ON T_GOLDEN_ID_MASTER.EMAIL = T_GOLDEN_PAIRS.LEFT1 Query submitted at: 2019-04-01 14:23:59 (Coordinator: http://x.x.x.x:25000) Query progress can be monitored at: http://x.x.x.x:25000/query_plan?query_id=1942482780696934:1be9ca8300000000 WARNINGS: Kudu error(s) reported, first error: Timed out: Failed to write batch of 21998 ops to tablet 5a3ff383cd97495d836b761efe2f7618 after 532 attempt(s): Failed to write to server: (no server available): Write(tablet: 5a3ff383cd97495d836b761efe2f7618, num_ops: 21998, num_attempts: 532) passed its deadline: Network error: recv error: Connection reset by peer (error 104) Error in Kudu table 'impala::ap_db.T_GOLDEN_ID_MASTER': Timed out: Failed to write batch of 21998 ops to tablet 5a3ff383cd97495d836b761efe2f7618 after 532 attempt(s): Failed to write to server: (no server available): Write(tablet: 5a3ff383cd97495d836b761efe2f7618, num_ops: 21998, num_attempts: 532) passed its deadline: Network error: recv error: Connection reset by peer (error 104) (1 of 66027 similar) NTP Error: Unable to read clock for last 10.258s: Service unavailable: Error reading clock. Clock considered unsynchronized I am using below Kudu configuration and rest is default configuration. maintenance_manager_num_threads = 4 memory_limit_hard_bytes = 25 GB block_cache_capacity_mb = 4GB Also I observed , query is pointing to single tablet server instead of 3 table servers, each server has 32GB RAM. Can someone please help ASAP to solve this issue ..? thank you in advance.
... View more
Labels:
- Labels:
-
Apache Kudu
03-25-2019
11:44 PM
While creating table , its failing with below error. Query: CREATE TABLE REPORTKUDU PRIMARY KEY(Marketing_Cloud_Visitor_ID) PARTITION BY HASH(Marketing_Cloud_Visitor_ID) PARTITIONS 10 STORED AS KUDU TBLPROPERTIES('kudu.master_addresses'='X.X.X.X','kudu.num_tablet_replicas'='1') AS SELECT * FROM REPORTN WARNINGS: Error applying Kudu Op.: Incomplete: buffer size limit is too small to fit operation: required 52236317, size limit 10485760 Key already present in Kudu table 'impala::db.REPORTKUDU'. (1 of 9006 similar)
... View more
Labels:
- Labels:
-
Apache Impala
-
Apache Kudu
03-16-2019
09:42 AM
Does Cloudera Hive supports for Insert ,Update and Delete on Table? Which is best option for Analytics Batch processing which supports UPDATES and JOINS on tables?
... View more
Labels:
- Labels:
-
Apache Hive