Search Discussions

76 discussions - 276 posts

  • HI , While executing query on datanode , i m getting following error . Query: select count(1) from test_data Error communicating with impalad: TSocket read 0 bytes [Not connected] Regards, Rakesh T.
    Mar 18, 2013 at 9:17 am
    Apr 2, 2013 at 8:26 am
  • x-post: http://stackoverflow.com/questions/15646377/impala-on-cloudera-cdh-could-not-create-logging-file-permission-denied I installed Impala via a parcel in the Cloudera Manager 4.5 on a CDH ...
    Jan MechtelJan Mechtel
    Mar 28, 2013 at 8:21 am
    Mar 29, 2013 at 12:23 am
  • Could you provide the query profiles for the queries you're testing? These will help identify where the bottleneck is. (Query profiles can be accessed via the impalad web interface at ...
    Skye Wanderman-MilneSkye Wanderman-Milne
    Mar 8, 2013 at 8:59 pm
    Dec 2, 2013 at 2:17 pm
  • Hi DK, i run into the same error as below. this error always occurs when submit a specific query. my impalad.INFO is below. --- I0311 18:47:48.205356 6272 progress-updater.cc:55] Query ...
    Yukinori SUDAYukinori SUDA
    Mar 11, 2013 at 10:33 am
    Apr 18, 2013 at 9:19 pm
  • The query "select * from scl limit 5" in Impala is sometimes fast (~5 seconds) but sometimes very slow (~2 minutes), much slower than in Hive. I can reproduce the slowness by first flushing the Linux ...
    Steven WongSteven Wong
    Mar 19, 2013 at 8:22 pm
    Mar 23, 2013 at 12:32 am
  • Hi, I'm following this tutorial: https://ccp.cloudera.com/display/IMPALA10BETADOC/Data+Loading+and+Querying+Examples - I modified directory permission: *[root@impala2 ~]# hadoop fs -ls /user/hive/ * ...
    Mar 25, 2013 at 12:52 am
    Apr 3, 2014 at 6:39 pm
  • 6.2 2013/3/1 Srinivasan Ramalingam <<span class="m_body_email_addr" title="fdd66d92aff4b64c8403bb36d20240e3" eceseenu19898.2@gmail.com</span
    Yanbo LiangYanbo Liang
    Mar 1, 2013 at 11:15 am
    Apr 19, 2013 at 9:18 am
  • Is there any way to print the results of an impala query through JDBC to hdfs? I would like the results of user's queries to be accessible in the future without the need to recompute and it would be ...
    Alan PapirAlan Papir
    Mar 21, 2013 at 3:22 pm
    Mar 21, 2013 at 9:03 pm
  • Can you provide what errors you're getting?
    Alex BreshearsAlex Breshears
    Mar 4, 2013 at 9:12 pm
    Mar 4, 2013 at 10:00 pm
  • I have tried to connect impala from oracle BI admin tools on Windows 7, but can not import metadata from the impala source. I could see the impala source, but can not get the table metadata within ...
    Gu PingGu Ping
    Mar 14, 2013 at 2:11 pm
    May 22, 2013 at 6:28 pm
  • Hi Barry, What version of Impala are you using? Can you also send us the explain plan? Thanks, Alan
    Mar 21, 2013 at 1:59 am
    Mar 25, 2013 at 3:28 pm
  • Hi Impala Users, I'm very glad to join this group and to talk with all of you. Impala is new to me, and I encountered a problem when I tried to use Impala on an existing hive table which had many ...
    Lake ChangLake Chang
    Mar 11, 2013 at 2:47 am
    Mar 13, 2013 at 3:29 pm
  • Hi All, I executed command like this *s**elect datediff('2012-12-15','2011-10-01')*in impala shell. it is executing properly and showing the difference. if i execute my below query its showing ...
    Anil KumarAnil Kumar
    Mar 26, 2013 at 4:14 am
    Mar 27, 2013 at 6:15 am
  • Could you also post the runtime profiles (also found in the logs) for both queries?
    Marcel KornackerMarcel Kornacker
    Mar 14, 2013 at 2:30 pm
    Mar 21, 2013 at 5:01 pm
  • Hi there. I would just like to double check that my understanding of hive/impala is correct (I am most likely missing something) *hive: *I have created a new table, inserted some data (via hive's ...
    Stephan KotzeStephan Kotze
    Mar 1, 2013 at 5:00 pm
    Mar 12, 2013 at 12:20 pm
  • The state store does not perform query delegation. The client (impala-shell) picks an impalad to submit the query to. Any impalad will do. See `impala-shell --help'. The impalad that receives the ...
    bc Wongbc Wong
    Mar 7, 2013 at 5:15 am
    Mar 22, 2013 at 4:15 am
  • Hi, I keep getting the 'unkown disk id ... location metadata' warnings, even though I have made necessary setup in Impala's hdfs-site.xml as well as the main HDFS site.xml. I have followed the ...
    Jaideep DhokJaideep Dhok
    Mar 15, 2013 at 9:42 am
    Mar 18, 2013 at 11:42 am
  • When I run multiple Impala queries (I can see 15 of them running at the same time) in parallel, they just hang and never complete. Any body can help with what is going on - is it a memory issue? ...
    Mar 22, 2013 at 2:39 pm
    Mar 29, 2013 at 3:02 pm
  • I am using the Impala 0.6 virtual machine with no other modifications other than populating HBase tables with my data. I want to be able to query my data in HBase via Impala and am not able to ...
    Nenshad BardoliwallaNenshad Bardoliwalla
    Mar 27, 2013 at 8:41 pm
    Mar 27, 2013 at 9:48 pm
  • Hi, I'm experiencing crash when running some simple aggregate Impala queries. This might turn out to be just memory allocation problem, but thought I would ask. As an example, I running: select ...
    Charles EarlCharles Earl
    Mar 14, 2013 at 4:53 am
    Mar 14, 2013 at 3:35 pm
  • Hi DK, Impala supports reading RC files, but does not yet support writing to RC files. Thanks, Lenni Software Engineer - Cloudera
    Lenni KuffLenni Kuff
    Mar 7, 2013 at 8:16 pm
    Mar 7, 2013 at 11:56 pm
  • Hi All, I am using the schema in the Impala VM and trying to create a dynamic partitioned table on date_dim. New table is called date_dim_i and schema for that is defined as: create table date_dim_i ...
    Mar 5, 2013 at 12:22 am
    Mar 5, 2013 at 1:49 am
  • Hi Kanghua, Impala does not provide a way to integrate external storage managers - the code that supports HDFS and Hbase is specific to those storage managers and performance-sensitive. If your goal ...
    Marcel KornackerMarcel Kornacker
    Mar 3, 2013 at 7:17 pm
    Mar 4, 2013 at 6:01 pm
  • We're profiling Impala and are curious as to the design of the Impala JDBC driver. We're running on 4 EC2 m1.large instances with standard non-EBS disks. *First Table Size* *Query Description* *num ...
    Scott RuffingScott Ruffing
    Mar 27, 2013 at 7:15 pm
    Mar 27, 2013 at 8:29 pm
  • I tried impala V0.6 on CentOS 5, using the rpm packages downloaded from cloudera.com. And the state-store is running ok. While impalad can run with --use-state-store=false. If set ...
    Aaron LeeAaron Lee
    Mar 18, 2013 at 10:22 am
    Mar 23, 2013 at 8:56 am
  • Hello Everyone, I like to know the process of Installing the Impala (esp impala-shell) as client to connect to Impala server running on Hadoop Cluster just like Hive. On my Hadoop Cluster, i've ...
    Sanjeev sagarSanjeev sagar
    Mar 21, 2013 at 5:49 pm
    Mar 22, 2013 at 4:58 pm
  • When running a select query from the impala-shell, I'm getting the following exception (hive queries work fine on this table): ERROR: com.google.common.util.concurrent.UncheckedExecutionException ...
    Jason MJason M
    Mar 16, 2013 at 12:56 am
    Mar 18, 2013 at 11:21 pm
  • It's very likely that you ran out of memory. To verify, please rerun this and simultaneously watch the memory consumption of the impalad process.
    Marcel KornackerMarcel Kornacker
    Mar 18, 2013 at 2:19 am
    Mar 18, 2013 at 5:42 pm
  • Hi, I have installed impala 0.6 and CDH 4.2, i have setuped my cluster with three data nodes and a namenode. First, i created a table data stored as TEXTFILE format in hive, And i have loaded about ...
    Mar 14, 2013 at 3:35 pm
    Mar 15, 2013 at 2:23 am
  • Hi all, I have deployed a pseudo cluster on my CentOS 6.3 64bit, then I want to launch a tpc-h benchmark on it. After successfully load data, create table and TPCH-HIVE. when I executed tpc-h-impala ...
    FU TianyuanFU Tianyuan
    Mar 14, 2013 at 9:23 am
    Mar 14, 2013 at 3:10 pm
  • I wish I could share some concerns with you regarding how the use of Impala is supposed to be promoted amongst non-JDBC environments, due to restrictive license terms. Let me add I'm not very good at ...
    Sékine CoulibalySékine Coulibaly
    Mar 6, 2013 at 4:02 pm
    Mar 14, 2013 at 12:52 pm
  • In compile instruction document README.md. One major point didn't metion. Before run /build_public.sh -build_thirdparty, You should install protobuf-2.4.1 in your machine. Like this: wget ...
    Mar 12, 2013 at 2:02 am
    Mar 13, 2013 at 1:51 am
  • I copied from /usr/include/boost/uuid from other machine to this node. That step compiled passed. 在 2013年3月9日星期六UTC+8上午9时39分07秒,FU Tianyuan写道:
    Mar 11, 2013 at 6:19 am
    Mar 11, 2013 at 8:46 am
  • Hi guys, Very exiting news that I just learned, Tableau 8 can connect to Impala! Congratulations Impala! One question I have, what need to be done on Impala server in order to establish the ...
    Echo LiEcho Li
    Mar 7, 2013 at 10:35 pm
    Mar 8, 2013 at 7:29 pm
  • Hi:All The Scan operation from A single query can be executed in parallel on one machine ? We know the map/reduce task can scan data one machine in parallel ,for there can be many slot for map ...
    Kang HuaKang Hua
    Mar 5, 2013 at 2:03 am
    Mar 6, 2013 at 10:04 am
  • Hi! I have installed cdh4.1,Hive0.9, Impala0.5 without Cloudera Manager as explained in the documentation and I can run queries in Hive without any errors, But i run a query of "select ... from ..." ...
    Mar 2, 2013 at 6:08 am
    Mar 4, 2013 at 5:03 am
  • Can anyone provide information on how best to interpret the Impala query profiles? Are there any existing write-ups on this that I haven't been able to find through searching? I've provided my ...
    Scott RuffingScott Ruffing
    Mar 29, 2013 at 2:29 pm
    Mar 29, 2013 at 7:05 pm
  • I just have some general questions. When is Impala 1.0 supposed to be released? I thought it was going to be the 1st quarter of 2013. When is AVRO support coming out? We are using AVRO extensively so ...
    Benjamin KimBenjamin Kim
    Mar 29, 2013 at 4:26 pm
    Mar 29, 2013 at 5:39 pm
  • My all my tables are name 0x_something Running SELECT COUNT(*) FROM 05_kissmetricis in Impala / HUE fails with: com.cloudera.impala.common.AnalysisException: Syntax error at: SELECT COUNT(*) FROM ...
    Jan MechtelJan Mechtel
    Mar 29, 2013 at 12:36 am
    Mar 29, 2013 at 12:44 am
  • Hi David - Not currently, I'm afraid. Is it possible to switch your client to use a buffered transport? Henry -- Henry Robinson Software Engineer Cloudera 415-994-6679
    Henry RobinsonHenry Robinson
    Mar 27, 2013 at 3:31 pm
    Mar 28, 2013 at 3:34 am
  • Hello I've been trying to run the following query from Java using the Impala JTDS driver: select * from our_transactions join our_products on (our_transactions.material_id = our_products.material_id) ...
    Fernando ElizondoFernando Elizondo
    Mar 26, 2013 at 2:45 pm
    Mar 26, 2013 at 7:40 pm
  • Hi All, ** when i try to execute query like *select * from bidemo.Customer. *it is showing bulk records. when i try to execute using where condition (select * from bidemo.Customer c where ...
    Anil KumarAnil Kumar
    Mar 25, 2013 at 7:12 am
    Mar 25, 2013 at 6:20 pm
  • Ahoy, I think I have Impala correctly configured, but I cannot see my hive metadata... so maybe I don't :P Everything is the latest CDH4 RPMs (2.0.0+552-1.cdh4.1.2.p0.27.el5) from Cloudera's repo ...
    Nathan MilfordNathan Milford
    Mar 22, 2013 at 6:45 pm
    Mar 22, 2013 at 9:54 pm
  • Please let me know whther Impala is compatible with Fedora15.
    Clementine JoeClementine Joe
    Mar 21, 2013 at 12:57 pm
    Mar 21, 2013 at 1:54 pm
  • Hi, I have just started looking into Impala and am using Cloudera manager 4.5 with CDH4.2.0 I have CM in a single node VM with around 2GB of RAM. I was just testing a couple of queries on Hive as ...
    Sachin HadoopSachin Hadoop
    Mar 20, 2013 at 2:05 pm
    Mar 20, 2013 at 2:37 pm
  • Hi, I am using Cloudera Manager 4.5 woth Impala beta installed in it. I would like to know if the only way to refresh the metastore is using the impala-shell ? *$ impala-shell -i impala-host -q ...
    Sachin HadoopSachin Hadoop
    Mar 19, 2013 at 10:01 am
    Mar 19, 2013 at 5:20 pm
  • Hi All, I am uisng centos 6.2 64 bit os. i am planning to install cdh4 and impala using CM. i already installed CM in my local system using rpm packages. can you please tell me the steps to follow ...
    Mar 16, 2013 at 8:06 am
    Mar 17, 2013 at 1:28 am
  • Materialized view can be very useful for frequent query, is there a plan to support MV in the future?
    Gu PingGu Ping
    Mar 15, 2013 at 5:36 am
    Mar 15, 2013 at 6:05 am
  • What version of Impala are you running? Could you provide us with more of the log file? Skye
    Skye Wanderman-MilneSkye Wanderman-Milne
    Mar 8, 2013 at 7:58 pm
    Mar 13, 2013 at 3:30 am
  • Hi list, Just FYI. My friend posted the slides, Performance evaluation of cloudera impala beta 0.6 in comparison with Hive on slideshare ...
    Tatsuo KawasakiTatsuo Kawasaki
    Mar 7, 2013 at 12:23 am
    Mar 12, 2013 at 5:45 pm
Group Navigation
period‹ prev | Mar 2013 | next ›
Group Overview
groupimpala-user @

74 users for March 2013

Marcel Kornacker: 29 posts Alan Choi: 13 posts Lenni Kuff: 11 posts Greg Rahn: 10 posts Darren Lo: 9 posts DK: 9 posts Jan Mechtel: 9 posts Henry Robinson: 8 posts RAKESH THERANI: 8 posts Sékine Coulibaly: 8 posts Thiswym: 7 posts Steven Wong: 7 posts Zjp...: 7 posts Anil Kumar: 6 posts Barry Becker: 6 posts Nong Li: 6 posts Kang Hua: 5 posts Ricky Saltzer: 5 posts Vikas Singh: 5 posts Yanbo Liang: 5 posts
show more