FAQ

Search Discussions

50 discussions - 163 posts

  • 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 RobinsonHenry 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 EizadiSoheil 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.deepakGvr.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 vadiwalaViresh 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 EvansJulia 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 AlberdiGregorio 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 CataniaGiuseppe 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 ...
    Qiffang33Qiffang33
    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 SasidharanSabarish 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 ...
    RealwangxRealwangx
    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 NguyenSummer 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 ...
    MartinMartin
    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 CrisanValentina 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 BasuAbhi 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 DuttaAmit 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 MarcColin 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 EvansJulia 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 LiuPengcheng 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-BizriJonathan 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 SasidharanSabarish 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 JacobsMatthew 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 BittorfVictor 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 SimmonsKeith 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 ...
    VladimirVladimir
    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 ShankarSrinath 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 BrownDavid 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 LaskyArt 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 LiNong 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 BhatnagarAniket 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 AristizabalMauricio 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 SasidharanSabarish 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 SUDAYukinori 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 NguyenSummer 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õiAleksei 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'BrienSean 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 ...
    MartinMartin
    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 EricksonJustin 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 JoshiIshaan 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 RigauxRomain 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 LeeAndrew 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 RobinsonHenry 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 SasidharanSabarish 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õiAleksei 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 KornackerMarcel 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.deepakGvr.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 LiuPengcheng Liu
    Jun 2, 2014 at 5:08 pm
    Jun 2, 2014 at 5:08 pm
Group Navigation
period‹ prev | Jun 2014 | next ›
Group Overview
groupimpala-user @
categorieshadoop
discussions50
posts163
users56
websitecloudera.com
irc#hadoop

56 users for June 2014

Alex Behm: 12 posts 邓 展成: 10 posts : 9 posts Sabarish Sasidharan: 6 posts Srinath Shankar: 6 posts Henry Robinson: 5 posts Ishaan Joshi: 5 posts Lenni Kuff: 5 posts Matthew Jacobs: 5 posts Soheil Eizadi: 5 posts Colin Marc: 4 posts John Russell: 4 posts Julia Evans: 4 posts Martin Terreni: 4 posts Nong Li: 4 posts Pengcheng Liu: 4 posts Skye Wanderman-Milne: 4 posts Summer Nguyen: 4 posts Victor Bittorf: 4 posts Viresh vadiwala: 4 posts
show more