Search Discussions
-
Hi - I see two problems here. The first is that it looks like you've set --cgroup_hierarchy_path=/tmp, but I bet that's not actually a cgroup hierarchy. Have you mounted a cgroup hierarchy on your ...
Henry Robinson
Jun 12, 2014 at 5:57 am
Sep 11, 2014 at 6:24 pm -
Thanks, that worked. As you see from the detail log the temporary AVRO table in Hive does not appear in Impala. Otherwise my preference would be to do it all from the Impala Shell, below I also put ...
Soheil Eizadi
Jun 16, 2014 at 9:47 pm
Jun 23, 2014 at 6:51 pm -
I have the same thing with cloudera impala. The sql get stuck and jeep on running especially when I collected stats. Let me know if you find a solution. I will also look around. Thanks Deepak Gattala ...
Gvr.deepak
Jun 18, 2014 at 2:31 am
Jun 25, 2014 at 8:15 am -
Hello, I am new to CDH. I have been trying out CDH 4.0 and now version 5.0.1-1.cdh5.0.1.p0.47. I was using Hive ODBC driver and it works fine from my C# test client for the above version. For ...
Viresh vadiwala
Jun 3, 2014 at 7:03 pm
Jun 5, 2014 at 2:51 pm -
We're seeing Impala queries stuck in the CREATED state forever. Right now every running query is in either CREATED or EXCEPTION, and the progress indicators I see are like "78 / 0 (0%)". Any idea ...
Julia Evans
Jun 26, 2014 at 6:26 pm
Jul 2, 2014 at 12:29 pm -
Impala retrieve wrong results in queries with joined aggregated subqueries. I notice this strangerous behaivour with aggregated subqueries joining diferent tables, but in the test i explain here, the ...
Gregorio Alberdi
Jun 18, 2014 at 9:30 am
Aug 26, 2014 at 8:41 am -
Hi everyone, I'm new to Cloudera Impala and I'm working on it in order to retrive data stored in hbase by effcient way. I've created an external impala table to mapping the fields of interest in ...
Giuseppe Catania
Jun 24, 2014 at 9:40 am
Jun 27, 2014 at 4:44 pm -
i create a hbase table named usertable by hive,when i enter 'invalidate metadata' in impala-shell,it is ok;i can see this table in impala-shell. when i enter "refresh usertable",it is ok. but when i ...
Qiffang33
Jun 23, 2014 at 5:54 am
Jun 23, 2014 at 3:48 pm -
I tried setting the JAVA_TOOL_OPTIONS. impala-server.log says that its been picked up. But still in the heap stats generated on failure, I see that the perm gen is still the old value of 24m. The ...
Sabarish Sasidharan
Jun 23, 2014 at 8:25 am
Jun 26, 2014 at 8:28 pm -
1, Can Imapla support binary data type ? if yes, how do ? 2, If impala can not support binary data type, how can i adapt binary to Impala. 3, If impala can not support binary date type , Is there has ...
Realwangx
Jun 17, 2014 at 3:41 am
Jun 19, 2014 at 5:56 pm -
Hi, Our task is : Parsing Game User action Log from text file to Structure type. I used to use Mysql. But I am planning to move to Impala which may be better for us. I have a very new Hadoop System ( ...
Summer Nguyen
Jun 2, 2014 at 7:58 am
Jun 5, 2014 at 5:06 am -
I would like to use Impala in an organisation with data kept in Hebrew. I read that Impala has some limitations when dealing with Unicode characters. Is the limitation related only to string ...
Martin
Jun 22, 2014 at 8:30 am
Jun 26, 2014 at 4:31 am -
Hello everybody, my colleagues in Bigstep did some performance testing with Impala and I think their findings are quite interesting. See the results here ...
Valentina Crisan
Jun 23, 2014 at 5:25 pm
Jun 25, 2014 at 8:30 am -
How to do something like this in Impala or Hive - select a series of columns from table B that are coming from a select of rows from table A? TABLE A ID NAME DESC ........... HG1 HG2 HG3 HG4 TABLE B ...
Abhi Basu
Jun 13, 2014 at 4:29 pm
Jun 13, 2014 at 7:02 pm -
Hi All, Is there a way to make webservice call thru Impala. I mean is there a rest way of making call to the hdfs data. *Thanks & Regards,* *Amit Dutta* To unsubscribe from this group and stop ...
Amit Dutta
Jun 12, 2014 at 4:06 am
Jun 13, 2014 at 6:31 pm -
Running something like 'FOO.BAR', we sometimes get an error like the following: Here's the full traceback: http://pastebin.com/4hdq0eFP. It seems to work if we run it a second time. Thanks in advance ...
Colin Marc
Jun 10, 2014 at 1:59 pm
Jun 10, 2014 at 10:33 pm -
We've been having some problems with Impala locking. Something strange that I noticed today is that there are active Beeswax sessions even though all the queries in the session have finished. We're ...
Julia Evans
Jun 10, 2014 at 7:03 pm
Jun 10, 2014 at 8:07 pm -
Hello Deepak I collected the stats on the table and make sure impala have enough memory to use. rerun the same query and the query failed and it killed the impala daemons. Let me know if you need ...
Pengcheng Liu
Jun 3, 2014 at 5:41 pm
Jun 4, 2014 at 6:59 pm -
Hello all, I'm just starting out with Impala, and have been following Cloudera's basic Impala Tutorial. However, I cannot get the Impala-shell to respond to anything but the 'tab tab' command list ...
Jonathan El-Bizri
Jun 26, 2014 at 7:50 pm
Jun 26, 2014 at 8:19 pm -
Hi all: We write a external data source, which connect to mysql, like hdfs data node running in impala. But is is not stable and sometimes get crash. Here is a sql executed in impala shell: select id ...
杨军
Jun 23, 2014 at 2:52 am
Jun 24, 2014 at 12:11 am -
Looking at the generated plans, it seemed like statistics would help. INSERT worked on running the stats. Still puzzling as to why CTAS worked without needing stats. To unsubscribe from this group ...
Sabarish Sasidharan
Jun 11, 2014 at 12:33 pm
Jun 13, 2014 at 4:39 am -
Hi Stephen, Can you share the query profile for one of the queries which exhibit this behavior? Thanks, Matt To unsubscribe from this group and stop receiving emails from it, send an email to ...
Matthew Jacobs
Jun 10, 2014 at 6:12 pm
Jun 12, 2014 at 12:43 am -
Sorry to hear you are running into problems with Llama. I'm going to see if I can reproduce this and figure out what's going on. Victor To unsubscribe from this group and stop receiving emails from ...
Victor Bittorf
Jun 10, 2014 at 7:28 pm
Jun 11, 2014 at 4:16 am -
I've noticed for a particular query that the bulk of the time is being spent materializing rows on the Hdfs Scan Node (if I'm reading the performance profile correctly). Here's the profile for a ...
Keith Simmons
Jun 9, 2014 at 8:35 pm
Jun 10, 2014 at 8:21 pm -
Hi, We just upgraded Impala from 1.2.4 - 1.3.1 and CDH from 4.6 - 4.7 and start getting Write problems (Read is ok): When trying to create table – it gives socket error: Query: create table test_5 (x ...
Vladimir
Jun 9, 2014 at 9:46 pm
Jun 10, 2014 at 5:06 pm -
Hi Kevin, Thanks for clarifying that. I assume the query that's failing is the following: select assembly.col0,(fa.fa)/(assembly.assembly) m,(assembly.assembly) assembly FROM ( SELECT 'overall' ...
Srinath Shankar
Jun 5, 2014 at 10:45 pm
Jun 6, 2014 at 4:53 pm -
All does the latest version of cloudera impala support composite keys? To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
David Brown
Jun 2, 2014 at 6:56 am
Jun 4, 2014 at 7:34 am -
Hi everyone, Apologies in advance if a similar question has been posted. But I need to ask. I was experimenting with LDAP authentication via trusted source. I followed the instructions as given in ...
Art Lasky
Jun 3, 2014 at 3:48 pm
Jun 3, 2014 at 7:00 pm -
Is there any chance you could share the data and schema to help us reproduce this? To unsubscribe from this group and stop receiving emails from it, send an email to ...
Nong Li
Jun 26, 2014 at 9:14 pm
Oct 11, 2014 at 9:29 am -
I have an existing Hive external table as follows: CREATE EXTERNAL TABLE participant (member_id BIGINT, ethnicity STRING, household_comp STRING) STORED BY ...
Aniket Bhatnagar
Jun 30, 2014 at 3:53 pm
Jun 30, 2014 at 9:45 pm -
The docs seem to imply that defining a sequencefile table with compression just requires specifying "stored as sequencefile" in table def, and then just setting ...
Mauricio Aristizabal
Jun 27, 2014 at 10:48 pm
Jun 28, 2014 at 9:19 pm -
Bumping to the top to get some eyeballs To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
Sabarish Sasidharan
Jun 23, 2014 at 10:24 am
Jun 27, 2014 at 7:53 am -
Hi all, We are using impala 1.3.1 with CDH 5.0.1 and cloudera manager 5.0.1. We sometimes run into the condition that there's no response to query for snappy-compressed parquet format table. Looks ...
Yukinori SUDA
Jun 17, 2014 at 9:18 am
Jun 17, 2014 at 5:45 pm -
hi, impala-user: I configure the impala on yarn with llama yesterday. when my table size ( of table `src_gprs_dzc`) is 300M, the impala-shell.sh on llama runs OK , but when my table size goes up to ...
邓 展成
Jun 12, 2014 at 3:27 am
Jun 13, 2014 at 3:47 pm -
Hi, impala-user: I run the bin/make_release.sh with the profile guided optimisation(set USE_PGO=1 in the make_release.sh ) to make the release build, but it failed. I found the service/runquery does ...
邓 展成
Jun 12, 2014 at 1:31 am
Jun 12, 2014 at 1:47 am -
Hello, I'm using ODBC for PHP to connect to Impala. in the /etc/odbc.ini , I set the following : HOST=10.40.8.12 ( an IMPALA Host) PORT=21050 *= ODBC works OK * if I set: HOST=10.40.8.15 ( A Haproxy ...
Summer Nguyen
Jun 9, 2014 at 8:29 am
Jun 10, 2014 at 7:39 pm -
When executing REFRESH <table command, I am getting the INFO notification in Impala daemon saying: Impala does not have WRITE access to 'hdfs://nameservice1/user/hive/warehouse/mytable/dt=20140318' ...
Aleksei Udatšnõi
Jun 5, 2014 at 7:24 am
Jun 6, 2014 at 3:53 pm -
Is there a way to do this? In monitoring my cluster I just noticed a 2h old describe table query running. I set idle_query_timeout to 600 hoping that would kill queries like this but I guess impala ...
Sean O'Brien
Jun 5, 2014 at 8:41 pm
Jun 5, 2014 at 10:25 pm -
I want to start developing my own version of Impala with changes for me specific needs. I just wanted a pointer where should I better start to introduce my self to it. BTW I already developed C++ on ...
Martin
Jun 30, 2014 at 6:39 am
Jun 30, 2014 at 6:39 am -
Hi, Impala-users and the corresponding cloudera teams: I think I have no permission to send email to the cdh-user@cloudera.org. so Please admit me to send this email to the impala-user@cloudera.org ...
邓 展成
Jun 28, 2014 at 5:29 am
Jun 28, 2014 at 5:29 am -
Hi Soheil, Parquet file format support for Solr will be delivered in a few weeks. Look for the CDH 5.1 release and upgrade once available. Let us know if there is anything else we can help with ...
Justin Erickson
Jun 27, 2014 at 2:23 am
Jun 27, 2014 at 2:23 am -
Colin, In the absence of a core dump, it would be helpful if you could provide the following information. - The queries which caused the crashes (along with their profiles) - schemas (if sharable) - ...
Ishaan Joshi
Jun 25, 2014 at 8:18 am
Jun 25, 2014 at 8:18 am -
To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
Romain Rigaux
Jun 23, 2014 at 5:05 am
Jun 23, 2014 at 5:05 am -
Hi All, I have a 5 nodes cluster that is running impala 1.2.4, but I'm getting the following error : I have one node running state-store and catalogd and impalad, and other 3 nodes running impalad ...
Andrew Lee
Jun 21, 2014 at 6:28 pm
Jun 21, 2014 at 6:28 pm -
Hi - I'm afraid I don't have any good ideas to suggest right now. If the middleware component is unable to forward through any information about who the original query is from, I'm not sure how ...
Henry Robinson
Jun 17, 2014 at 5:49 pm
Jun 17, 2014 at 5:49 pm -
Thats all of the stack in the logs (coordinator-log). I didn't prune the stack. Is there some other place I should be looking at, for the stack? Also I am facing this issue today even after running ...
Sabarish Sasidharan
Jun 17, 2014 at 8:47 am
Jun 17, 2014 at 8:47 am -
Yes, I know that REFRESH should be used. However if someone (by mistake) doesn't refresh the queries shouldn't just hang, should they? To unsubscribe from this group and stop receiving emails from ...
Aleksei Udatšnõi
Jun 12, 2014 at 3:50 pm
Jun 12, 2014 at 3:50 pm -
Impala can run against hbase, and in your particular use case that may well be a very good option. Depending on how you set up the mapping from hbase into the Impala table schema, Impala will be able ...
Marcel Kornacker
Jun 10, 2014 at 11:31 pm
Jun 10, 2014 at 11:31 pm -
What are the volume of the data in those tables you are joining. Did you use partitioning. Did you collect stats. Thanks Deepak Gattala Sent via the Samsung Galaxy Note® 3, an AT&T 4G LTE smartphone ...
Gvr.deepak
Jun 2, 2014 at 7:18 pm
Jun 2, 2014 at 7:18 pm -
Hello guys We discovered the issue this morning. When running join queries like below one will crash impala daemons, and also the query will fail with error info ERRORS: Cancelled due to unreachable ...
Pengcheng Liu
Jun 2, 2014 at 5:08 pm
Jun 2, 2014 at 5:08 pm
Group Overview
| group | impala-user |
| categories | hadoop |
| discussions | 50 |
| posts | 163 |
| users | 56 |
| website | cloudera.com |
| irc | #hadoop |
56 users for June 2014
Archives
- November 2014 (94)
- October 2014 (212)
- September 2014 (162)
- August 2014 (218)
- July 2014 (200)
- June 2014 (172)
- May 2014 (149)
- April 2014 (150)
- March 2014 (197)
- February 2014 (180)
- January 2014 (269)
- December 2013 (207)
- November 2013 (174)
- October 2013 (141)
- September 2013 (145)
- August 2013 (149)
- July 2013 (288)
- June 2013 (299)
- May 2013 (317)
- April 2013 (220)
- March 2013 (276)
- February 2013 (147)
- January 2013 (129)
- December 2012 (109)