Member since
09-09-2013
14
Posts
5
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2475 | 08-15-2014 12:13 PM | |
5570 | 04-14-2014 08:54 AM | |
2727 | 04-14-2014 08:42 AM |
12-17-2018
11:35 AM
Hi @Big I checked on our latest build and it works for me - see below. Are you sure that you're not trying to query a table with a DATE type column? [localhost:21000] default> create table foo2 (`date` int);
Query: create table foo2 (`date` int)
+-------------------------+
| summary |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 1.19s
[localhost:21000] default> select distinct `date` from foo2;
Query: select distinct `date` from foo2
Fetched 0 row(s) in 0.12s
... View more
08-28-2018
01:47 PM
there is a possibility that your daemon process is hung find it and kill it $> ps -eaf|grep impala impala 4399 1 0 Aug17 ? 00:00:00 python2.7 /usr/lib64/cmf/agent/build/env/bin/cmf-redactor /usr/lib64/cmf/service/impala/impala.sh impalad impalad_flags false clouder+ 8426 5709 0 16:34 pts/0 00:00:00 grep --color=auto impala impala 12322 1 0 Aug17 ? 00:00:00 /opt/cloudera/parcels/CDH-5.10.1-1.cdh5.10.1.p0.10/lib/impala/sbin-retail/impalad --flagfile=/run/cloudera-scm-agent/process/3639-impala-IMPALAD/impala-conf/impalad_flags $>sudo kill -9 12322 $>sudo kill -9 4399 try to restart your daemon and check the port $> sudo netstat -lntp|grep 22000
... 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
04-15-2014
08:58 PM
hey ,my friend,i want to build impala source by impala-1.3.0-chd5.tar.gz,there are many problems.can you give me some guids or is there a notebook?
... 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