Search Discussions

47 discussions - 149 posts

  • Hello CDH and Impala Users, We are pleased to announce the version 2.5 release of the Cloudera ODBC Driver for Apache Hive™ and Cloudera ImpalaTM. This version adds: - Significantly enhanced ODBC API ...
    Wendy TurnerWendy Turner
    Aug 29, 2013 at 10:11 pm
    Oct 13, 2013 at 3:28 pm
  • Hi all, I install Impala on Ubuntu server 12.04 using Cloudera Manager 4.6.2, Parcels. Then I add services: HDFS, Hive, MapReduce, Impala. HDFS, Hive, MapReduce services work fine, the status is Good ...
    Aug 8, 2013 at 3:17 pm
    Sep 4, 2013 at 4:45 pm
  • How many distinct values are there of (p_log_file_date, p_log_file_min) in the source table? e.g. select p_log_file_date, p_log_file_min, count(*) from qb__s_dm_base_log group by p_log_file_date, ...
    Greg RahnGreg Rahn
    Aug 9, 2013 at 2:36 am
    Aug 12, 2013 at 7:39 am
  • please, take a look at this question i posted on the stack: http://stackoverflow.com/questions/18109030/creating-impala-external-table-from-a-partitioned-file-structure
    Pavel KatsevPavel Katsev
    Aug 7, 2013 at 6:55 pm
    Aug 7, 2013 at 9:28 pm
  • Hi Sabarish, It looks like the problem is that one of the needed Parquet JARs (parquet-hive-1.0.jar) is not in the Impala's CLASSPATH. I'm assuming you are running Impala v1.1.1, correct? I have a ...
    Lenni KuffLenni Kuff
    Aug 28, 2013 at 4:55 am
    Dec 3, 2013 at 6:50 pm
  • Hi everyone, My system is Ubuntu server 12.04 using Cloudera Standard 4.6.2. last 2 day my Impala service still work fine. But today it stop working and show this error: *Supervisor returned FATAL ...
    Aug 26, 2013 at 9:24 am
    Aug 27, 2013 at 3:34 pm
  • I have recently upgraded Impala to v1.0.1. I get error "RPC Error: Deprecated RPC; please update your client" when I run refresh command from Impala-shell prompt. Other commands and queries are ...
    Aug 1, 2013 at 3:56 pm
    Aug 1, 2013 at 9:21 pm
  • My application is using Impala by impyla module from Python. If user input is inserted into an SQL query directly, the application becomes vulnerable to SQL injection, like in the following example ...
    Shinya OkanoShinya Okano
    Aug 30, 2013 at 2:15 am
    Sep 3, 2013 at 7:35 pm
  • Hi The impalad always crash in execute group by query. It succeed after I set disable_codegen=true. How can I set it to true in default? My impala version is 1.1.1.
    Aug 8, 2013 at 10:12 am
    Aug 9, 2013 at 12:49 am
  • Hi Rene - Could you re-run the query and provide the profile? If you're running these queries from the shell, you can just type "profile" after running a query to obtain the full query profile ...
    Ricky SaltzerRicky Saltzer
    Aug 7, 2013 at 7:08 pm
    Aug 8, 2013 at 6:30 pm
  • We found a lot of active sessions on the session page http://impala-server:25000/sessions of our DEV impala server. Some of them began at the time when the server was restarted on 7/30 and are still ...
    Bewang TechBewang Tech
    Aug 7, 2013 at 10:23 pm
    Aug 8, 2013 at 6:01 pm
  • Hi Guys, I have a lot of flat CSV files on HDFS already. I regularly run MR jobs against the data. I have now installed Impala and am going to play with that. However, I am not clear on the best flow ...
    Bob WebmanBob Webman
    Aug 5, 2013 at 5:09 pm
    Aug 7, 2013 at 7:12 pm
  • You'll really need to provide more info on the issue you're seeing: what version of QlikView? Windows version? CDH version? Are you trying to connect to Impala or Hive? And what error message are you ...
    Jonathan SeidmanJonathan Seidman
    Aug 1, 2013 at 4:37 pm
    Aug 6, 2013 at 5:34 pm
  • Hi, Maybe you are root and don't have hdfs permissions. Try with hdfs user account or similar Franck Le 2 août 2013 11:21, "Screenthong Lapmahapaisan" <<span class="m_body_email_addr" ...
    Franck GallosFranck Gallos
    Aug 2, 2013 at 10:56 am
    Aug 5, 2013 at 3:01 am
  • Hi, I'm analyzing my IMPALA queries, I'm I correct in assuming the DataStream Sender section relates to networking. Can you provide a quick explanation? I think my queries are network bound. Attached ...
    Andrew StevensonAndrew Stevenson
    Aug 30, 2013 at 3:20 pm
    Aug 31, 2013 at 7:44 am
  • Hello, After some issues with space on disk on the cluster, we free some space and try to reboot the cluster. But Impala Services won't start up. The only log available are from ...
    Nicolas PhungNicolas Phung
    Aug 9, 2013 at 1:32 pm
    Aug 12, 2013 at 8:31 am
  • Hello, I'm trying to get around 100 TB of data from protobuf to Parquet. One way is to use the "INSERT into TABLE parquet_table select * from raw_table" and running it in impala but this can take a ...
    Aug 9, 2013 at 4:56 am
    Aug 9, 2013 at 5:47 pm
  • Hi, I have a trouble with RCFile when query on it using IMPALA: 1. I using HiBench Tool to create 18Gb uncompress sequence file and insert into uservisits. 2. Using Hive to create table with format ...
    Long kyoLong kyo
    Aug 8, 2013 at 2:44 am
    Aug 9, 2013 at 1:10 am
  • Hi Guys, For those that have ever followed Cloudera's example to stream tweets ( https://github.com/cloudera/cdh-twitter-example ) I have made a few prototype enhancements to write to HBASE instead ...
    Aron MacDonaldAron MacDonald
    Aug 8, 2013 at 8:00 am
    Aug 8, 2013 at 2:21 pm
  • Hi Guys, We have upgraded to IMPALA 1.1 via Cloudera Manger 4.6 using the parcels. We now get the following error when querying LZOP tables via IMPALA. Backend 0:Impala LZO library was built against* ...
    Aug 2, 2013 at 1:47 pm
    Aug 5, 2013 at 9:57 am
  • Hello, Can you please clarify if the following is correct behavior (same thing happens for FLOAT type): create table table1 ( col INT ); insert into table1 values (1+1); Query: insert into table1 ...
    Aug 1, 2013 at 9:03 pm
    Aug 1, 2013 at 9:32 pm
  • Hi Aniket, Impala uses the Hive Metastore to persist catalog metadata, but currently each Impalad maintains its own independent cache of this metadata. This means a table/db created on Node1 will not ...
    Lenni KuffLenni Kuff
    Aug 27, 2013 at 4:53 am
    Aug 27, 2013 at 9:58 pm
  • I was wondering if I have understood well. it's a strict requirement to have impala and hdfs running on the same nodes, isn't it? thanks surfer To unsubscribe from this group and stop receiving ...
    Aug 27, 2013 at 7:52 am
    Aug 27, 2013 at 8:59 am
  • how exactly Impala works? What happens when you submit a query? How the data will be transferred to different nodes? To unsubscribe from this group and stop receiving emails from it, send an email to ...
    Aug 26, 2013 at 10:25 am
    Aug 26, 2013 at 3:32 pm
  • Hi guys, my hbase column has three version value. version1 has some value,version2 has some value and version3 has some value. when i query the hbase table using impala i get new version value only ...
    Srinivasan RamalingamSrinivasan Ramalingam
    Aug 26, 2013 at 6:26 am
    Aug 26, 2013 at 3:27 pm
  • Impala users, If you're in the SF Bay Area, or even if you're not, consider joining the new Bay Area Impala User Group: http://www.meetup.com/Bay-Area-Impala-Users-Group/ We'll be hosting meetings on ...
    Justin KestelynJustin Kestelyn
    Aug 21, 2013 at 6:58 pm
    Aug 22, 2013 at 1:02 am
  • Can you share the error message you get? To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
    Nong LiNong Li
    Aug 21, 2013 at 6:26 pm
    Aug 21, 2013 at 7:19 pm
  • Hi, I want to insert some data into a table from another table using JDBC driver. Statement.executeUpdate finished immediately but statement needs few seconds to finish. I cannot determine when ...
    Dejan ProkićDejan Prokić
    Aug 11, 2013 at 10:56 pm
    Aug 12, 2013 at 5:27 am
  • Hello ;-) current impala query result to hdfs file, we must to use create external table with insert overwrite table. but we hope to support query result to save hdfs directly. have you a plan to ...
    Aug 11, 2013 at 5:57 am
    Aug 11, 2013 at 10:25 pm
  • Petter, Impala does not support nested types yet. Support for them will be added sometime later this year. Thanks Ishaan
    Ishaan JoshiIshaan Joshi
    Aug 6, 2013 at 4:37 pm
    Aug 9, 2013 at 9:15 am
  • Hi, Is there any recommendation for HW setup for Imapla? (eg.: suggested cores per disk?) Thank you, Gyorgy
    György BaloghGyörgy Balogh
    Aug 6, 2013 at 2:44 pm
    Aug 6, 2013 at 3:30 pm
  • Hi there - The best way to learn how a query is distributed is to read both the query plan and query profile. The* query plan* is an abstract representation of how Impala interpreted and intends to ...
    Ricky SaltzerRicky Saltzer
    Aug 5, 2013 at 2:44 pm
    Aug 6, 2013 at 2:07 am
  • I have moved the parquet jars to the HIVE lib directory. Now my script creates an external table which points at a parquet table created in IMPALA. I also had to include extra jars I built from the ...
    Andrew StevensonAndrew Stevenson
    Aug 31, 2013 at 7:45 am
    Aug 31, 2013 at 7:45 am
  • I now can't reproduce what I did to make parquet files readable by HIVE. I'm hitting a ClassNotFoundError? Here's my HIVE script to try and read a table I created in IMPALA. ADD JAR ...
    Andrew StevensonAndrew Stevenson
    Aug 30, 2013 at 3:31 pm
    Aug 30, 2013 at 3:31 pm
  • Hello CDH, Impala and Cloudera Manager Users, We are pleased to announce the release of Cloudera Impala version: 1.1.1. This is a maintenance release that contains defect fixes and improvements ...
    Wendy TurnerWendy Turner
    Aug 28, 2013 at 12:51 am
    Aug 28, 2013 at 12:51 am
  • Hi Errors occurred when I create a table on the impala by executing the following command *create EXTERNAL TABLE tab1 ( id INT, col_1 BOOLEAN, col_2 DOUBLE, col_3 TIMESTAMP ) ROW FORMAT DELIMITED ...
    Aug 23, 2013 at 9:19 am
    Aug 23, 2013 at 9:19 am
  • Interesting. So it started to fetch some results but the Impalad could not do it apparently. I am adding impala-user in case they have a better explanation. Romain To unsubscribe from this group and ...
    Romain RigauxRomain Rigaux
    Aug 23, 2013 at 3:08 am
    Aug 23, 2013 at 3:08 am
  • Thanks for the help Skye, it worked. This files was generated manually from java compressor class. Thanks, Kashif -- Cheers, Kashif To unsubscribe from this group and stop receiving emails from it, ...
    Kashif KhanKashif Khan
    Aug 21, 2013 at 3:10 pm
    Aug 21, 2013 at 3:10 pm
  • Hi Andrew, Are you able to run ANALYZE TABLE <table name COMPUTE STATISTICS on a text based table? If that also fails, then it is most likely a configuration problem. Please make sure you have made ...
    Lenni KuffLenni Kuff
    Aug 21, 2013 at 3:06 pm
    Aug 21, 2013 at 3:06 pm
  • Hi, It seems impala cannot handle nested structures in one record. Is that true? Are you planning to support this in the future? Thnak you, Gyorgy
    György BaloghGyörgy Balogh
    Aug 10, 2013 at 6:11 am
    Aug 10, 2013 at 6:11 am
  • Here's the full profile Query (id=c84a511a9fa7b8b4:12d138bbd3a88ea6): Summary: Start Time: 2013-08-09 09:38:25.572066000 End Time: 2013-08-09 09:40:23.286857000 Query Type: DML Query State: FINISHED ...
    Aug 9, 2013 at 2:02 am
    Aug 9, 2013 at 2:02 am
  • When I run the following command in our DEV env, I can find 181 connections to hive metastore thrift server. In our DEV env, only 6 developers use impala and we use RPC to refresh catalog time to ...
    Bewang TechBewang Tech
    Aug 8, 2013 at 6:20 pm
    Aug 8, 2013 at 6:20 pm
  • Dan, This seems like an instance of IMPALA-432<https://issues.cloudera.org/browse/IMPALA-432 . I've updated the issue to add your datapoint. In the meanwhile, for queries with huge IN predicates, ...
    Ishaan JoshiIshaan Joshi
    Aug 7, 2013 at 7:07 pm
    Aug 7, 2013 at 7:07 pm
  • Dan, This is indeed a bug. I'll file an isssue. "The query doesn't return any error when run in the impala-shell, it simply prints the query that's being run (even though --quiet was specified) and ...
    Ishaan JoshiIshaan Joshi
    Aug 6, 2013 at 4:39 pm
    Aug 6, 2013 at 4:39 pm
  • Hi I have an impala test cluster with 3 nodes with impala 1.1.1. In the past Jul, everything runs fine. Since yesterday, following error happens on one node. [t-hd-03:21000] desc ...
    Aug 6, 2013 at 2:51 am
    Aug 6, 2013 at 2:51 am
  • Sachin, The best way to invalidate the metadata on the all the nodes is to issue the query at each node in your cluster. Thanks, Ishaan On Sun, Aug 4, 2013 at 9:39 PM, Sachin Aggarwal wrote:
    Ishaan JoshiIshaan Joshi
    Aug 5, 2013 at 11:05 pm
    Aug 5, 2013 at 11:05 pm
  • Hi, I am having trouble connecting Qlikview. When I give connect or test connection, its throwing an error.
    Nancy jeanNancy jean
    Aug 1, 2013 at 11:37 am
    Aug 1, 2013 at 11:37 am
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
groupimpala-user @

58 users for August 2013

Lenni Kuff: 12 posts 邱睿: 10 posts Ishaan Joshi: 7 posts Andrew Stevenson: 6 posts Nguyen Dang Minh: 6 posts Vikas Singh: 6 posts Greg Rahn: 5 posts John Russell: 5 posts Bewang Tech: 4 posts Henry Robinson: 4 posts Jonathan Seidman: 4 posts Nong Li: 4 posts Skye Wanderman-Milne: 4 posts Alex Behm: 3 posts Big: 3 posts Marcel Kornacker: 3 posts Pavel Katsev: 3 posts Ricky Saltzer: 3 posts Sachin Aggarwal: 3 posts Screenthong Lapmahapaisan: 3 posts
show more