Member since
04-18-2016
21
Posts
1
Kudos Received
0
Solutions
01-31-2024
10:43 PM
2 Kudos
Hi @Dan Burkert , i have tried exactly the same DDL and it give the error. I used hue/impala to create the table. Can you help? ParseException: Syntax error in line 4:undefined: RANGE(year, month) ( ^ Encountered: RANGE Expected: CACHED, COMMENT, LOCATION, PARTITION, PARTITIONED, PRODUCED, ROW, SORT, STORED, TBLPROPERTIES, UNCACHED, WITH CAUSED BY: Exception: Syntax error
... View more
10-20-2020
10:13 AM
@kundansonuj Impala tables should have less than 30K partitions to ensure you get the necessary performances. The workaround would be to recreate tables with less partitions.
... View more
04-23-2018
02:26 AM
This table is monthly range partitioned with day as hash partition. This seems to had happen due to load on server during the specific time. https://issues.apache.org/jira/browse/KUDU-1078 I had to create a new table and delete previous one to get data insertion started, but this has happened again with a different table, providing ksck logs: Tablet 5e5edc9ab5f84dbe8ef3f1e650057cd1 of table 'impala::vertoz.tbl_bid_winimp' is under-replicated: 1 replica(s) not RUNNING
080aabc3c7c94e178e107f09b7959c15 (data-node-4.vrtzads.com:7050): RUNNING
2fe8aae066c1491788f5044a8db31524 (cicloud2.ny1vrtzads.com:7050): bad state
State: FAILED
Data state: TABLET_DATA_READY
Last status: Incomplete: Unable to load Consensus metadata: Could not read header for proto container file /home/kudu/tserver/consensus-meta/5e5edc9ab5f84dbe8ef3f1e650057cd1: File size not large enough to be valid: Proto container file /home/kudu/tserver/consensus-meta/5e5edc9ab5f84dbe8ef3f1e650057cd1: Tried to read 16 bytes at offset 0 but file size is only 0 bytes
9d754b0276bf4a04a46e2fe0d8d414f6 (data-node-3.vrtzads.com:7050): RUNNING [LEADER]
2 replicas' active configs differ from the master's.
All the peers reported by the master and tablet servers are:
A = 080aabc3c7c94e178e107f09b7959c15
B = 2fe8aae066c1491788f5044a8db31524
C = 9d754b0276bf4a04a46e2fe0d8d414f6
The consensus matrix is:
Config source | Voters | Current term | Config index | Committed?
---------------+------------------------+--------------+--------------+------------
master | A B C* | | | Yes
A | A B C | 5 | -1 | Yes
B | [config not available] | | |
C | B C | 5 | 7 | No
Table impala::vertoz.tbl_bid_winimp has 17 under-replicated tablet(s)
WARNING: 2 out of 7 table(s) are not in a healthy state
==================
Errors:
==================
table consistency check error: Corruption: 2 table(s) are bad
FAILED
Runtime error: ksck discovered errors
... View more
02-27-2018
10:51 AM
1 Kudo
Hi @kundansonuj I think it(s almost same issue reported in this Apache JIRA ticket: https://issues.apache.org/jira/browse/IMPALA-5399 Any way check my answer (https://issues.apache.org/jira/browse/IMPALA-5399#comment-16166044) I have already use it and it's work.. Good luck.
... View more
10-06-2017
06:45 AM
Hello, What version of CM are you running? If you are still running CM5.10.2, you will not see any CDH versions availble for upgrade that are higher than the CM version. Upgrade CM to 5.12.x and you will then be able to upgrade to CDH5.12.x Tina
... View more