Search Discussions

89 discussions - 288 posts

  • Hi: Does some ever use JDBC of impala. We encounter following error when using jdbc Caused by: org.apache.thrift.protocol.TProtocolException: Required field -- Anty Rao
    Anty RaoAnty Rao
    Jul 18, 2013 at 9:04 am
    Sep 5, 2014 at 10:32 pm
  • Impala version 1.0.1 with CDH 4.3.0 *Data * * * [06:40][<span class="m_body_email_addr" title="463b50bd25fc3b09291cc8e56a299749" wand@node401.stg</span tpc-h-impala]$ hadoop dfs -cat ...
    Jul 18, 2013 at 7:11 am
    Jul 22, 2013 at 4:24 pm
  • Hi All, Recently a few of us following this forum have collaborated and compiled some interesting Impala bench-marking results. We've used the TPC-H data-set on our small HADOOP clusters to test ...
    Aron MacDonaldAron MacDonald
    Jul 22, 2013 at 4:14 pm
    Feb 28, 2014 at 3:31 pm
  • I has a snappy file ,and load the file into the table by hive,I can query it in hive ,but do not in impala,if I want to do it in impala ,anyone tell me why,ths.
    Zhong shiZhong shi
    Jul 16, 2013 at 2:37 pm
    Dec 1, 2013 at 3:58 pm
  • hi can i use odbc connectors to connect impala server from php page thanks sachin aggarwal
    Sachin AggarwalSachin Aggarwal
    Jul 22, 2013 at 1:43 pm
    Aug 23, 2013 at 11:57 pm
  • Hi, When I submit a join query,Planner compute the broadcast cost, and the cost is always 0,I find impala catalog that doesn't collect the num_rows and other statistics. Anyone met the problem?
    Qiang ZhouQiang Zhou
    Jul 9, 2013 at 6:33 am
    Jul 10, 2013 at 12:27 am
  • Hi, I have a problem regarding Pentaho community version connection towards Impala. I am using Pentaho CDE for dashboard creation and Pentaho Report Designer for classic reports. We installed Impala ...
    Darko LugomerDarko Lugomer
    Jul 8, 2013 at 11:16 am
    Jun 24, 2014 at 9:28 am
  • Hello CDH, Impala and Cloudera Manager Users, *Impala 1.1:* We are pleased to announce the release of Cloudera Impala version: 1.1. This release includes the following new features: - Sentry ...
    Wendy TurnerWendy Turner
    Jul 24, 2013 at 7:07 pm
    Aug 6, 2013 at 9:24 pm
  • There was an error I was facing where Impala can't seem to detect rows of a table whose data is stored in the RCfile format. But the new release impala 1.1-1.p0.8 seemed to have fixed it. However, ...
    Amlesh JayakumarAmlesh Jayakumar
    Jul 30, 2013 at 12:26 am
    Aug 1, 2013 at 4:55 pm
  • Hello, I'v been trying to grok the query profiles of some of the queries we'r running while benchmarking Impala to better understand what's really causing bottlenecks. There's a lot of good info in ...
    Jul 24, 2013 at 4:12 am
    Jul 24, 2013 at 3:56 pm
  • Hi All, I had performed the following query which include the modulus operator in impala but I got NullPointerException: *[MYRNDSVRVM311:21000] select (3.55 % 2) from city;* *Query: select (3.55 % 2) ...
    Jul 30, 2013 at 9:17 am
    Sep 4, 2013 at 3:56 am
  • Hi: Impala seems support dynamic partition very well when inserting data into partitioned table. However, if i specify partition column value statically when loading data, such as execute following ...
    Anty RaoAnty Rao
    Jul 29, 2013 at 3:41 pm
    Aug 7, 2013 at 3:03 am
  • This sounds like reasonable behavior. You are basically comparing best case (parquet optimized for scans) to worst case (hbase optimized for key access) with a query that does zero filtering so there ...
    Greg RahnGreg Rahn
    Jul 20, 2013 at 6:16 pm
    Jul 23, 2013 at 7:32 pm
  • Hi, can anyone tell me the command to load data into an Impala table? Suppose I have a txt file in my local how can I load it into the table? Like how we do in Hive, is there any load command?
    Nancy jeanNancy jean
    Jul 15, 2013 at 6:40 am
    Jul 15, 2013 at 4:28 pm
  • my data stored in hdfs has 10 columns in my impala's external table. I added one more column when i query for existing columns also i receive 0 rows as output is there a way to do this... -- Thanks & ...
    Sachin AggarwalSachin Aggarwal
    Jul 31, 2013 at 10:36 am
    Aug 2, 2013 at 5:58 pm
  • Hi, we are currently checking out Impala especially in conjunction with the parquet format. We already have a table (from csv files) that works pretty well. But when converting the table into parquet ...
    Raphael André BauerRaphael André Bauer
    Jul 15, 2013 at 10:00 am
    Jul 25, 2013 at 3:59 pm
  • I have a 6 node cluster with impalad's running and node401 running state store. the queries are being divided among all nodes as expected but am not able to fire queries from all the nodes but from ...
    Jul 20, 2013 at 12:04 am
    Jul 21, 2013 at 7:02 am
  • I am new this community and also this stack. I created my table in parquet format. I now want to load my data (in tsv format) into it. For my initial workload, i can assume the data is static (will ...
    Arun JagatheesanArun Jagatheesan
    Jul 10, 2013 at 11:05 pm
    Jul 11, 2013 at 9:14 pm
  • Hi:All I run following SQL query against a table with parquet format. and the query plan is : PLAN FRAGMENT 0 Impala choose broadcast join, and the query takes about 8 minutes to complete. Taking ...
    Anty RaoAnty Rao
    Jul 8, 2013 at 3:44 pm
    Jul 11, 2013 at 6:28 am
  • Impala reads table metadata from the Hive Metastore. This includes information about the directory in HDFS to read. The individual blocks are located by communicating with the HDFS Namenode. Henry -- ...
    Henry RobinsonHenry Robinson
    Jul 2, 2013 at 3:45 pm
    Jul 10, 2013 at 9:03 am
  • Hi , I tried to install Impala by following steps mentioned in cloudera site but it failed to find impala components after adding repository. [training@localhost yum.repos.d]$ ls CentOS-Base.repo ...
    Jul 7, 2013 at 4:49 pm
    Jul 9, 2013 at 2:21 pm
  • Hi, At the latest github commits of 1.1, start-impala-cluster.py doesn't work. ./bin/start-impala-cluster.py Traceback (most recent call last): File "./bin/start-impala-cluster.py", line 23, in ...
    Min YuMin Yu
    Jul 27, 2013 at 1:05 pm
    Aug 29, 2013 at 3:27 pm
  • Hi Iago, Can you run these queries using Hive and see if you get the expected results? It would help to debug this more if you could provide: 1) The query/queries that are affected 2) The "CREATE ...
    Lenni KuffLenni Kuff
    Jul 28, 2013 at 9:05 pm
    Jul 30, 2013 at 2:52 pm
  • Hi, A query with 3 subqueries failed with Impala on bad status request. I describe the query : - query(subquery A join subquery B) : OK Impala + Hive - subquery C test alone : OK Impala + Hive - ...
    Franck GallosFranck Gallos
    Jul 18, 2013 at 12:54 pm
    Jul 22, 2013 at 5:53 pm
  • I'm a little fuzzy on the post-install instructions from this page ...
    Matt KennedyMatt Kennedy
    Jul 5, 2013 at 5:51 pm
    Jul 8, 2013 at 5:28 pm
  • In HDFSTable.java I noticed that Impala supports DistributedFileSystem. Is it possible to add a shim layer which can support any FS so that one can extend DFS and impala will be able to use it ? What ...
    Jul 1, 2013 at 9:34 pm
    Jul 2, 2013 at 8:08 pm
  • Hi, Can I install and configure Impala along with Hortonworks?
    Nancy jeanNancy jean
    Jul 2, 2013 at 7:58 am
    Jul 2, 2013 at 3:46 pm
  • Hi All, I’m wondering if a partnership between Cloudera Impala and IBM Cognos is possible (like the one with Microstrategy). It would be a very good news for me to hear about an optimized Impala ODBC ...
    Thomas SauvagnatThomas Sauvagnat
    Jul 26, 2013 at 8:38 am
    Jul 26, 2013 at 7:51 pm
  • Hi, Impala itself should not be limited to ASCII, but it appears there are some issues with the client tools (impala-shell and Hue). I've filed https://issues.cloudera.org/browse/IMPALA-489 to get ...
    Lenni KuffLenni Kuff
    Jul 26, 2013 at 6:18 pm
    Jul 26, 2013 at 6:39 pm
  • I see "RUNNING" queries in Cloudera Manager 4.6 activities tab. Some of them are running for several days. I try to "CANCEL" them but nothing happens. Queries are still in activities list. I've tried ...
    Serega SheypakSerega Sheypak
    Jul 24, 2013 at 11:35 am
    Jul 25, 2013 at 8:27 am
  • The JDBC driver does not currently support PreparedStatement. This should be resolved in a future release of the driver. Thanks, Lenni
    Lenni KuffLenni Kuff
    Jul 23, 2013 at 4:34 pm
    Jul 24, 2013 at 7:21 pm
  • I created a hive table using the following to create the table *ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe *I can query the table in hive without any issues. But once I query ...
    Gerardo DelgadoGerardo Delgado
    Jul 23, 2013 at 6:50 pm
    Jul 23, 2013 at 7:40 pm
  • I've seen on some older threads that there was once an option called: num_threads_per_disk I'm doing some comparative testing on disk & flash right now, and while I'm seeing much better performance ...
    Matt KennedyMatt Kennedy
    Jul 22, 2013 at 1:35 am
    Jul 22, 2013 at 3:43 pm
  • Hi Anton, I get this error: (If i set replication factor to 1, the error goes away) 13/07/18 09:27:34 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using ...
    Paul BirniePaul Birnie
    Jul 18, 2013 at 4:12 pm
    Jul 18, 2013 at 9:53 pm
  • Hi, Round-robin scheduling is used to submit queries to different Impala nodes.And one query coordinator is selected in round robin fashion that Query coordinator initiates execution on remote ...
    Nehasingh Ns12Nehasingh Ns12
    Jul 17, 2013 at 1:31 pm
    Jul 18, 2013 at 10:06 am
  • Hi Stephan - There is an Impala parameter that controls the maximum number of concurrent connections, and as you discovered it's set to 64 by default. The parameter can be changed by setting ...
    Henry RobinsonHenry Robinson
    Jul 5, 2013 at 7:55 pm
    Jul 16, 2013 at 7:24 pm
  • We have Impala 1.0 installed in our environment along with CDH4.2.1. This morning we saw that not all the nodes had their metadata refreshed automatically for a new table. The table was introduced ...
    Benjamin KimBenjamin Kim
    Jul 10, 2013 at 4:51 pm
    Jul 10, 2013 at 6:39 pm
  • Hi Nancy - While HBase uses HDFS to store a table's HFile, it's still a different storage manager as far as Impala is concerned. HBase provides a different set of APIs to get at data, for example, ...
    Ricky SaltzerRicky Saltzer
    Jul 5, 2013 at 10:16 pm
    Jul 8, 2013 at 5:14 pm
  • Hi, Can anyone please explain how the query is converted into collection of plans? Please explain to me in a flow.
    Nancy jeanNancy jean
    Jul 2, 2013 at 8:51 am
    Jul 8, 2013 at 8:11 am
  • Hi All, I am getting errors on a very simple query, select * from tableX order by id DESC LIMIT 10 Some background: - the table in question here has two lzo files with index files in hdfs. - i have ...
    Ravi BhattRavi Bhatt
    Jul 1, 2013 at 11:38 am
    Jul 2, 2013 at 6:24 pm
  • Which version of Impala are you running?
    Marcel KornackerMarcel Kornacker
    Jul 1, 2013 at 4:00 pm
    Jul 1, 2013 at 6:48 pm
  • Hi Impala and Hue workers, Two suggests for increase the user experience of Impala and Hue : Fist, as Hive, why we can't save the results of Impala query in Hue ? Second, always in a datamaning ...
    Franck GallosFranck Gallos
    Jul 29, 2013 at 11:54 am
    Jul 29, 2013 at 11:41 pm
  • Hi, I'm trying to import data from CSV file containing escaped commas. My input complies with RFC4180 (http://tools.ietf.org/html/rfc4180) Example: "foo", "foo, bar", foo Using the CREATE TABLE I can ...
    György BaloghGyörgy Balogh
    Jul 25, 2013 at 5:50 pm
    Jul 25, 2013 at 6:09 pm
  • Did the Cloudera guys notice following code snippet from Read-write-util.h in your github repos. template< the second method #GetInt should be GetLongInt -- Anty Rao
    Anty RaoAnty Rao
    Jul 25, 2013 at 3:20 am
    Jul 25, 2013 at 6:00 am
  • Query: insert overwrite table customer_1 select * from customer Query failed Backend 0:AVRO not implemented. ERROR: AVRO not implemented. I'm using Impala 1.0.1 on CDH4.2.0.
    Bewang TechBewang Tech
    Jul 23, 2013 at 2:27 pm
    Jul 23, 2013 at 4:30 pm
  • Hello, I'm beginner to use impala. Now we are using impala to analyze apache logs. we made table named 'apache' by hive metastore. This table is using serde2.RegexSerDe like below ROW FORMAT SERDE ...
    Jul 19, 2013 at 7:41 am
    Jul 22, 2013 at 10:12 pm
  • Does Impala have any built-in hash functions like MD5, murmur-32, etc...? The reason I am asking is because I wanted to perform an online sample of a string column by taking its hash and mod'ing it ...
    Amlesh JayakumarAmlesh Jayakumar
    Jul 22, 2013 at 7:28 pm
    Jul 22, 2013 at 8:33 pm
  • How does the user know which impala daemon it has to connect to. Suppose a node is dead and statestore knows about this. Who makes sure that the query is not sent there? Does the statestore interfere ...
    Nancy jeanNancy jean
    Jul 10, 2013 at 8:59 am
    Jul 19, 2013 at 4:56 pm
  • How many users can access impala simultaneously Or how many queries can run simultaneously?
    Nehasingh Ns12Nehasingh Ns12
    Jul 17, 2013 at 1:36 pm
    Jul 18, 2013 at 9:55 am
  • Hi, I created a table in Hive referencing CSVSerde and loaded my data into the Hive table. I can query the table from Hive and everything's fine, but when I query it from Impala I get this error ...
    Nick MartinNick Martin
    Jul 15, 2013 at 6:50 pm
    Jul 15, 2013 at 7:00 pm
Group Navigation
period‹ prev | Jul 2013 | next ›
Group Overview
groupimpala-user @

74 users for July 2013

Nancy jean: 24 posts Anty Rao: 15 posts Lenni Kuff: 15 posts Gautam: 12 posts Henry Robinson: 12 posts Greg Rahn: 11 posts Ricky Saltzer: 11 posts Marcel Kornacker: 10 posts Alan Choi: 9 posts Darren Lo: 8 posts Franck Gallos: 8 posts Nong Li: 8 posts Sachin Aggarwal: 8 posts Zhong shi: 7 posts Paul Birnie: 6 posts Raphael André Bauer: 6 posts Nehasingh Ns12: 5 posts Amlesh Jayakumar: 5 posts Manuel Stopnicki: 5 posts Qiang Zhou: 5 posts
show more