Member since
09-09-2013
14
Posts
5
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2036 | 08-15-2014 12:13 PM | |
4790 | 04-14-2014 08:54 AM | |
2340 | 04-14-2014 08:42 AM |
10-09-2014
01:35 PM
2 Kudos
Hi Sree, Impala allows keywords to be used as identifiers (table/db/column/etc names), but you must escape them using backticks. For example, notice keywords are being used below: SELECT `date` FROM `database`.`table`; Hope that helps. Thanks, Lenni
... View more
08-15-2014
12:13 PM
Hi, The issuing a REFRESH will broadcast the updated table to all nodes. There may be a short delay after the command completes before the changes are visible on remote nodes. This is because we must wait for a statestore update to propagate the changes out. If you need stronger consistency guarantees (the change is visible on all nodes at the time it completes) you can use the query option: SET SYNC_DDL=true This will impact DDL performance, so it is disabled by default. For optimal performance, you can batch your DDL statements and only enable this query option for the final statement in the batch. For example: > connect to node 1 CREATE TABLE Foo ALTER TABLE ADD PARTITION 1 .. SET SYNC_DDL=true ALTER TABLE ADD PARTITION N > connect to node2 SELECT * FROM TABLE Thanks, Lenni
... View more
05-09-2014
09:13 AM
Hi, I have filed https://issues.cloudera.org/browse/IMPALA-990 to track this issue. Impala should fail to start if any of the thrift servers cannot start. Thanks, Lenni
... View more
05-08-2014
12:08 PM
What if you run "select 1" (leave out the FROM clause)? Thanks, Lenni
... View more
05-08-2014
10:01 AM
Hi Ram, Are you able to successfully run "select 1" on every impalad node? If you are running CM, can you check the Cluster Health to see if there are any warnings or errors reported? It will be hard to debug your issue further unless we have more of your log file. Thanks, Lenni
... View more
04-14-2014
08:54 AM
1 Kudo
You might be pointing to an old Impala repo under /etc/yum.repos.d/. You can either cleanup the old repo files under /etc/yum.repos.d/ or force only the CDH5 repo to be used: sudo yum install impala --disablerepo='*' --enablerepo="cloudera-cdh5" Thanks, Lenni
... View more
04-14-2014
08:42 AM
Hi Minutis, Have you tried upgrading to Impala v1.2.4? We made some enhancements in that release to fetch partitions in batches which should resolve your problem. Thanks, Lenni
... View more