FAQ

Hadoop > impala-user > November 2013

Search Discussions

36 discussions - 174 posts

  • Hi - How large are these nodes? (i.e. disk, cpu, memory). Could you prefix your query with EXPLAIN and provide the output of that? That will give us a better idea of what kind of query you are ...
    Ricky SaltzerRicky Saltzer
    Nov 6, 2013 at 6:30 pm
    Nov 15, 2013 at 4:10 pm
  • Sorry - I should've specified that this is from the packages on ubuntu precise. To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
    Colin MarcColin Marc
    Nov 26, 2013 at 10:16 am
    Dec 30, 2013 at 8:48 pm
  • Hi, We are running big query over our 20+ query over a partitioned table. We were monitoring impalad process and noticed that the CPU not going over 13% usage on a 8 core node. We are wondering if ...
    Michaël MimeaultMichaël Mimeault
    Nov 11, 2013 at 5:09 pm
    Nov 20, 2013 at 7:37 pm
  • I have an Impala 1.1.1 cluster running fine. I was able to create parquet tables, insert and query. I wanted hive to recognize the parquet table..so I did this ALTER TABLE currency SET SERDE ...
    FotographsFotographs
    Nov 1, 2013 at 6:31 pm
    Nov 6, 2013 at 9:34 pm
  • Hi, I'm trying to read data from Impala to Qlikview using the ODBC driver 2.5.5 that I downloaded today. Connections work and I can get results on small queries and aggregations. CDH version is CDH ...
    Fredrik RagnarFredrik Ragnar
    Nov 4, 2013 at 5:09 pm
    Nov 27, 2013 at 11:04 am
  • Well, I did it like that and it's fine. I wanted to do it like I wrote to make the query easier to read because it takes two screens. I am happy to hear that you are working on CROSS JOIN. Dejan ...
    Dejan ProkićDejan Prokić
    Nov 28, 2013 at 11:15 pm
    Feb 18, 2014 at 9:51 am
  • Hi, We use a custom serdes in hive and we want to use impala. But as of now, it is not supported in impala. I there a plan to support custom serdes in impala ? If yes, are there any timelines ? Or ...
    AtangriAtangri
    Nov 12, 2013 at 10:19 pm
    Jan 9, 2014 at 4:04 pm
  • Hi, I've seen this error in earlier posts but it might be a different one. I have a one machine installation (one disk, 8 GB RAM, Core I7, Ubuntu 12.04, Impala 1.1.1-1.p0.17) I uploaded a text file ...
    György BaloghGyörgy Balogh
    Nov 16, 2013 at 4:59 pm
    Nov 20, 2013 at 7:23 pm
  • Hey, So I've been trying to build impala since yesterday, and was able to get through a few hoops, but now I am unable to build thrift. I get the following error: /usr/include/event2/util.h:641:33 ...
    Prasan SamtaniPrasan Samtani
    Nov 24, 2013 at 7:14 pm
    Nov 26, 2013 at 4:07 pm
  • Here is what i did - CDH4.4 : 1. Create Parquet table: hive create table a1 (x int) OK 2. Create test data to insert into Parquet table: hive create table csv1 (test string) OK Time taken: 0.364 ...
    matt Liebermatt Lieber
    Nov 18, 2013 at 11:26 pm
    Dec 17, 2013 at 4:49 pm
  • Hi All, I am having one issue here. I had sqoop data into hive using snappy compression. I am able to query that table (sequence file with snappy compression) in hive without any issue but I got the ...
    ChiewyeaChiewyea
    Nov 7, 2013 at 6:25 am
    Dec 1, 2013 at 4:11 pm
  • Hi all, I'm a rookie in using impala, now i can run impala on my tiny cluster (3 virtual machine,1 master and 2 slaves), but after I run a few jobs, I find that there are many free computation ...
    Peter WellerPeter Weller
    Nov 12, 2013 at 1:05 pm
    Nov 13, 2013 at 7:08 am
  • Hi all, My objective is to have 2 parquet table in Impala. One will be partitioned and the other not, so I can do some benchmark. I can easily import data into Impala without partitions by just ...
    Michaël MimeaultMichaël Mimeault
    Nov 6, 2013 at 2:57 pm
    Nov 11, 2013 at 5:10 pm
  • So I've built impala from source, and I am running CDH5 in pseuo-distributed mode. Hive runs fine and the metastore is set up. I've also set up my configuration files in fe/src/test/resources as you ...
    Prasan SamtaniPrasan Samtani
    Nov 28, 2013 at 5:45 pm
    Jun 26, 2014 at 1:05 pm
  • Hello, After Upgrading from CDM 4.7.1 to CDM 4.8.0 (+ CDH 4.4.0 to CDH 4.5.0) & Impala 1.1 to Impala 1.2.1, the oozie shell action that was working before produced stderr logs and make the oozie ...
    Nicolas PhungNicolas Phung
    Nov 28, 2013 at 11:42 am
    Jun 20, 2014 at 1:51 pm
  • Hi guys, Impala is hosted on github. But I just knew Impala doesn't accept pull request and use JIRA to attach a patch ...
    Masahiro NakagawaMasahiro Nakagawa
    Nov 26, 2013 at 9:52 am
    Dec 22, 2013 at 6:40 pm
  • How much memory is configured for impala? It's a launch param, specified via impalad_flags Do you have cloudera manager installed? If so you can see what the memory usage in that node is at the time ...
    Sabarish SasidharanSabarish Sasidharan
    Nov 22, 2013 at 2:24 am
    Nov 22, 2013 at 3:26 am
  • Hi, I could not find ODBC driver for ubuntu (12.04) on the ODBC download page. Is there any workorund? Thank you, Gyorgy To unsubscribe from this group and stop receiving emails from it, send an ...
    György BaloghGyörgy Balogh
    Nov 7, 2013 at 2:46 pm
    Nov 8, 2013 at 1:16 am
  • Hi, I've set up a CDH cluster with CM. I didn't install impala when set up the cluster. Now when I try to add impala service, I get this message: Your selected service cannot be used due to missing ...
    Rui LiRui Li
    Nov 27, 2013 at 5:38 am
    Nov 27, 2013 at 5:30 pm
  • Hi, I'm new to impala and trying to create an external table. The data is stored in a csv file. As an example: create external table foo(bar int) row format delimited fields terminated by ',' stored ...
    Monika MoserMonika Moser
    Nov 26, 2013 at 3:56 pm
    Nov 27, 2013 at 3:15 pm
  • Thanks, that at least gets me to the point where I have a new error :) It's the same one as this: https://groups.google.com/a/cloudera.org/forum/#!topic/impala-user/X4TBbMGDOlk I guess I should just ...
    Prasan SamtaniPrasan Samtani
    Nov 24, 2013 at 5:52 pm
    Nov 25, 2013 at 1:01 am
  • Hi experts, AFAIK if hdfs performs the balancer to rebalance blocks between DNs, I need to query "invalidate metadata" to refresh impala's Catalog which include information about the location of ...
    Jung-Yup LeeJung-Yup Lee
    Nov 21, 2013 at 10:06 pm
    Nov 22, 2013 at 11:37 pm
  • Hi, When I load data into sequence tables into Cloudera Hive, the default serDe seems to be Simple and not binary, this is, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe. Such tables can be read ...
    Romeu KerstenRomeu Kersten
    Nov 15, 2013 at 7:38 pm
    Nov 20, 2013 at 7:10 pm
  • Hi, I saw there is a LIMIT command in Impala, but I can just give the max, not the starring position like in MySQL. I would like to query something like this: Select * from DB LIMIT 1000,1000 but I ...
    Klausen SchaefersinhoKlausen Schaefersinho
    Nov 15, 2013 at 2:34 pm
    Nov 15, 2013 at 3:47 pm
  • Dear CDH, Cloudera Manager, Cloudera Impala, and Cloudera Search users, We are pleased to announce the general availability of CDH 4.5, Cloudera Manager 4.8, Cloudera Impala 1.2.1, and Cloudera ...
    Wendy TurnerWendy Turner
    Nov 25, 2013 at 11:59 pm
    Dec 10, 2013 at 6:57 pm
  • Hi, Documentation says this for coalesce: *Return type:* same as the initial argument value Anyway, coalesce(integer, integer) returns bigint, so I need to cast its result to integer if I want to ...
    Dejan ProkićDejan Prokić
    Nov 28, 2013 at 7:03 pm
    Nov 28, 2013 at 10:56 pm
  • Hi, I am getting strange results from a query which does left join of tables with null values. Here is an example: Data: create table test_join_a(x integer, y integer); create table test_join_b(x ...
    Dejan ProkićDejan Prokić
    Nov 28, 2013 at 6:49 pm
    Nov 28, 2013 at 10:48 pm
  • in the query fragment ,what's is the meaning of "non-child" ? thanks To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.
    IctwangleiIctwanglei
    Nov 20, 2013 at 2:10 am
    Nov 21, 2013 at 7:24 pm
  • Hi Where should I look for failure information related to impalad going down. I see in the CM that one of the impalad instance was down for approx 4 mins this am around 6:40 am. I go to the logs dir ...
    Sabarish SasidharanSabarish Sasidharan
    Nov 21, 2013 at 1:10 pm
    Nov 21, 2013 at 4:38 pm
  • I am planning to use Impala with Parquet format on HDFS to serve as a huge database holding billions of entries. I am currently evaluating CDH4. In our case data is to be continuously ingested into ...
    Ananth GundabattulaAnanth Gundabattula
    Nov 15, 2013 at 6:52 pm
    Nov 20, 2013 at 6:56 pm
  • Hi all, I cant create external table with partitioned column in hive with the below script, CREATE EXTERNAL TABLE Opportunity_par(key string,Opportunity__Id string,Campaign__Name string) its showing ...
    Naren SanNaren San
    Nov 19, 2013 at 10:14 am
    Nov 19, 2013 at 3:18 pm
  • Got it building! Will write a post on this tomorrow in case anyone else is trying to build on Fedora19. Thanks for the help! To unsubscribe from this group and stop receiving emails from it, send an ...
    Prasan SamtaniPrasan Samtani
    Nov 25, 2013 at 4:16 am
    Nov 25, 2013 at 4:16 am
  • Hi Alexander, On Thu, Nov 21, 2013 at 5:20 AM, Alexander Schätzle wrote: That is correct. At the moment, Impala only supports flat relational tables, and you won't be able to map nested Parquet data ...
    Marcel KornackerMarcel Kornacker
    Nov 21, 2013 at 5:28 pm
    Nov 21, 2013 at 5:28 pm
  • Impala users, For those of you are located in the SF Bay Area: The Bay Area Impala UG is meeting at Cloudera's Palo Alto offices on the evening of Tues Dec. 17 ...
    Justin KestelynJustin Kestelyn
    Nov 20, 2013 at 11:19 pm
    Nov 20, 2013 at 11:19 pm
  • Andrew, I believe you need the Thrift jar as well. You can get it at : http://mvnrepository.com/artifact/com.twitter/parquet-thrift Matt To unsubscribe from this group and stop receiving emails from ...
    matt Liebermatt Lieber
    Nov 18, 2013 at 10:23 pm
    Nov 18, 2013 at 10:23 pm
  • Will the open-source version of Impala work with Apache Hadoop 1.0.4 distribution (not CDH) ? To unsubscribe from this group and stop receiving emails from it, send an email to ...
    AmitsAmits
    Nov 10, 2013 at 3:47 pm
    Nov 10, 2013 at 3:47 pm
Nov 2013
Group Navigation
period‹ prev | Nov 2013 | next ›
Group Overview
groupimpala-user @
categorieshadoop
discussions36
posts174
users50
websitecloudera.com
irc#hadoop

50 users for November 2013

Fotographs: 18 posts Michaël Mimeault: 15 posts Alex Behm: 12 posts Prasan Samtani: 11 posts György Balogh: 8 posts Ricky Saltzer: 7 posts Fredrik Ragnar: 6 posts Greg Rahn: 6 posts Henry Robinson: 6 posts Marcel Kornacker: 6 posts Matthewcornell: 5 posts Anurag Tangri: 5 posts Skye Wanderman-Milne: 5 posts Alan Choi: 4 posts Colin Marc: 3 posts James Duong: 3 posts John Russell: 3 posts Klausen Schaefersinho: 3 posts Chiewyea: 2 posts Darren Lo: 2 posts
show more
Archives