FAQ

Hadoop > impala-user > May 2014

Search Discussions

42 discussions - 147 posts

  • I used the instructions here - http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_impala_jdbc.html HiveServer2 is running Connecting from ...
    Abhi BasuAbhi Basu
    May 22, 2014 at 6:37 pm
    May 30, 2014 at 8:04 pm
  • Hi folks, is there a tag for 1.3.1 in https://github.com/cloudera/impala? Alternatively, could someone point to the commit that marked the release? Would love to have the tag added as we're compiling ...
    Soam AcharyaSoam Acharya
    May 13, 2014 at 4:15 am
    Jul 7, 2014 at 9:38 pm
  • Hi, I've been playing around with some new models to improve performance / reliability of some of our data pipelines. One of the big changes I've made is to shift some heavy weight intermediate ...
    Sean O'BrienSean O'Brien
    May 28, 2014 at 9:07 pm
    May 30, 2014 at 4:24 pm
  • Use Parquet with gb block size with snappy hope that works Thanks Deepak Gattala Sent via the Samsung Galaxy Note® 3, an AT&T 4G LTE smartphone <div -------- Original message --------</div <div ...
    Gvr.deepakGvr.deepak
    May 15, 2014 at 7:13 pm
    May 29, 2014 at 8:16 pm
  • Hello experts I have been working with impala for a year and now the new parquet format is really exciting. I had impala version vcdh5-1.3.0 I had a data set about 40G size in parquet (raw data is ...
    Pengcheng LiuPengcheng Liu
    May 8, 2014 at 3:15 pm
    May 18, 2014 at 7:22 am
  • Hi, I upgraded from CDH4.6 to CDH5.0.2. I had Oozie workflow that ran Impala-shell commands using shell scripts (sh) When trying to to a test and run shell: impala-shell -i hadoop1 -d default -q ...
    Yoni DarashYoni Darash
    May 27, 2014 at 5:35 pm
    Jun 18, 2014 at 7:24 pm
  • I've found this post " https://groups.google.com/a/cloudera.org/forum/#!msg/impala-user/dasBCGABdlw/cdGwSGOd8f8J", and John said that this was fixes in impala 1.1.1, I am afraid not Following is the ...
    Zesheng WuZesheng Wu
    May 7, 2014 at 8:31 am
    May 18, 2014 at 7:24 am
  • Hi impala/CDH users, We are running CDH 4.6.0 and decided to upgrade impala from 1.2.4 to 1.3.1 yesterday. After seeing some issues with a fairly simple union query providing erratic / different ...
    Sean O'BrienSean O'Brien
    May 7, 2014 at 6:55 pm
    May 8, 2014 at 9:55 pm
  • Hi Silaphet, Glad you've been having a good experience with Sentry so far! As you suspected, you should configure LDAP group mappings in the HDFS service, then in Hive configuration set ...
    Darren LoDarren Lo
    May 30, 2014 at 3:15 am
    Jun 4, 2014 at 6:21 pm
  • Hi all, I'm testing if Impala still works with old data after adding new columns. It does work for querying old columns but when I query the new columns, it seems not right. I'm wondering is Impala ...
    Tivona HuTivona Hu
    May 19, 2014 at 4:15 am
    May 23, 2014 at 7:03 pm
  • Hi All, I have an old parquet table with many many partitions that I'd like to use in hive (I'm on CDH 4.6 and impala 1.2.3). I'm stuck though because any describe or alter statement in hive runs ...
    Sean O'BrienSean O'Brien
    May 22, 2014 at 11:14 pm
    May 23, 2014 at 9:26 pm
  • We just upgraded Impala to 1.3.1 and find there are many error messages when making a query. ERRORS ENCOUNTERED DURING EXECUTION: Backend 1:Parquet file should not be split into multiple ...
    Tivona HuTivona Hu
    May 5, 2014 at 7:09 am
    May 20, 2014 at 2:43 pm
  • Is there any update on when the CDH 5 update parcel will be released that contains Impala 1.3.1? We're currently running into a bug (https://issues.cloudera.org/browse/IMPALA-935) in Impala 1.3.0 ...
    Kevin FarmerKevin Farmer
    May 13, 2014 at 2:31 pm
    May 13, 2014 at 6:33 pm
  • Hi Impalans I have a query which is taking 7 seconds on CSV backed tables and 70 seconds on Parquet backed tables. I have computed stats on both sets of tables. I have also run several other queries ...
    ChasChas
    May 1, 2014 at 12:54 pm
    May 2, 2014 at 3:16 pm
  • Hello Experts, I am trying to create an UDF which accepts 4 parameters in input and returns string. Same UDF jar file works perfectly on Hive. However Impala gives the following error ...
    Shrinath ParikhShrinath Parikh
    May 1, 2014 at 3:04 pm
    May 1, 2014 at 8:08 pm
  • Hi Guys, I'm experimenting with multi-core parallelism in Impala, and trying to run a 2-node impala cluster on a 48 core - 250GB RAM server. One of the Impala daemons crashes while executing a simple ...
    GauravGaurav
    May 1, 2014 at 6:28 am
    May 1, 2014 at 6:43 pm
  • In your page, on configuring Impala to work with JDBC you have a link to a zip file containing the JDBC driver and other required components. it is at ...
    Impala newbieImpala newbie
    May 29, 2014 at 12:32 am
    Jun 3, 2014 at 3:29 pm
  • Hi, I am new to Parquet+Impact. I have created a Parquet file (using map-reduce). I am accessing this Parquet file from Impala. I can access all the columns from Impala if the Parquet schema is ...
    Mahesh GMahesh G
    May 8, 2014 at 3:33 am
    May 8, 2014 at 5:35 pm
  • Hi, Just wondering if it's possible for impala (1.1.1) to read from a hive table which has multiple partition types, some of which are impala-compatible (e.g. parquet) and some of which are not ...
    Matt zMatt z
    May 6, 2014 at 5:24 pm
    May 6, 2014 at 6:07 pm
  • Hello Experts! I have observed very weird scenario working with Impala UDF. Looks like IMPALA somewhere persistently stores the jar file. Or atleast the details of it. I made a UDF and then removed ...
    Shrinath ParikhShrinath Parikh
    May 5, 2014 at 7:15 pm
    May 5, 2014 at 9:50 pm
  • Hello, I'm deploying CDH4 with Impala on my system. I have problem when use unixODBC. What I have done : - install impala run OK - Configure ODBC as the attached files I got a simple PHP script like ...
    Summer nguyenSummer nguyen
    May 28, 2014 at 10:29 am
    Jun 2, 2014 at 7:29 am
  • Hi Matt, Were you able to fins an answer to this? Please share if you have. I ran into this same problem but not using impala. Created a Parquet table in Hive and loaded data, When i try to do a hive ...
    Jothikumar EkanathJothikumar Ekanath
    May 30, 2014 at 11:27 pm
    Jun 2, 2014 at 12:11 am
  • Hello, i've activated ldap authentication on latest impala version (IMPALA 1.3.1-1.impala1.3.1.p0.1172). It works as expected when i provide password. But when there is no password it just allows ...
    Евгений ШишкинЕвгений Шишкин
    May 30, 2014 at 12:28 pm
    May 30, 2014 at 3:49 pm
  • Impala-Shell: Select count(*) from t1where cast(time as timestamp) '2011-10-26 08:46:18'; Returns OK the count JDBC with latest dependencies from Mavel: Select count(*) from t1 where cast(time as ...
    George KallosGeorge Kallos
    May 28, 2014 at 9:46 am
    May 29, 2014 at 6:39 pm
  • Hello All, I was wondering if anyone is using the jdbc drivers as documented as given in the link below to test the connectivity to impala 1.3.1 ? ...
    Ananth GundabattulaAnanth Gundabattula
    May 28, 2014 at 10:31 am
    May 29, 2014 at 12:54 am
  • Is there a special setting/way to read output from Impala - as a stream? For example, if I do a "*select * ...* " and it returns a lot of information, is there a way to get (partial) results as soon ...
    Mahesh GMahesh G
    May 15, 2014 at 7:08 pm
    May 15, 2014 at 7:12 pm
  • I donot think so, I've tried 256MB block size, it also works. Sent from my MiPhone Pengcheng Liu <<span class="m_body_email_addr" title="37afa6aaf7e0f1473dfac6d57aa44835" [email protected]</span 编写： ...
    Wuzesheng86Wuzesheng86
    May 13, 2014 at 2:54 pm
    May 14, 2014 at 2:54 pm
  • We are using impala 1.2.3 and hue 2.5.0. It looks like Create Table as Select (CTAS) is not atomic. When we cancel a CTAS midway, we still see table created with no data. Ideally, we would have ...
    Sukhendu chakrabortySukhendu chakraborty
    May 8, 2014 at 10:38 pm
    May 9, 2014 at 3:38 pm
  • I am using Micro strategy 9.3.1. There is no driver available for Impala. Could you please help ..? I have installed Clodera ODBC driver for Impala ,Created DSN. How to use that DSN in Microstrategy ...
    Deepali SakundeDeepali Sakunde
    May 5, 2014 at 7:59 am
    May 5, 2014 at 5:00 pm
  • Hi, I have a 5 node cluster with a table containing 4 billion rows. The table format is Parquet. Until a few days ago everything worked just fine and all query's performed realy good. But now for ...
    MwullinkMwullink
    May 4, 2014 at 3:20 pm
    May 4, 2014 at 10:39 pm
  • That's great news. I am expecting better performance than Shark even for the first-time query. Thanks, Jung-Yup Lee To unsubscribe from this group and stop receiving emails from it, send an email to ...
    Jung-Yup LeeJung-Yup Lee
    May 2, 2014 at 1:49 am
    May 2, 2014 at 1:53 am
  • Hi, I am trying to estimate and profile the maximum per node memory usage of an query. The dataset for testing is from here ...
    ShumingShuming
    May 1, 2014 at 8:30 am
    May 1, 2014 at 6:44 pm
  • Impala users, We have recently completed comparative testing (based on open TPC-DS-derived queries) of the state-of-the-art options for SQL-on-Hadoop: Impala, Hive-on-Tez (Hive 0.13), Presto, and ...
    Justin KestelynJustin Kestelyn
    May 29, 2014 at 9:50 pm
    May 29, 2014 at 9:50 pm
  • I am seeing the same problem. When I look at the diagnostics log, it shows the following error message. Any ideas of what could be done to fix this problem? Thanks ...
    Nin LeiNin Lei
    May 22, 2014 at 8:12 pm
    May 22, 2014 at 8:12 pm
  • same query in hive and impala: select event_time, unix_timestamp(event_time), unix_timestamp(event_time, 'yyyy-MM-dd HH:mm:ss.S'), unix_timestamp(event_time, 'yyyy-MM-dd HH:mm:ss.SSS'), ...
    Teng QiuTeng Qiu
    May 22, 2014 at 9:54 am
    May 22, 2014 at 9:54 am
  • *PreparedStatement, spring jdbctemplate does not close the associated server-side operation. * *all queries are open and consume frgments in impala.* *is there a workaround for this * To unsubscribe ...
    Bhargav ramBhargav ram
    May 16, 2014 at 6:02 pm
    May 16, 2014 at 6:02 pm
  • Dear CDH, Cloudera Manager, and Cloudera Impala users, We are pleased to announce the release of Cloudera Enterprise 5.0.1 (CDH 5.0.1 and Cloudera Manager 5.0.1) and Cloudera Manager 4.8.3. Cloudera ...
    Wendy TurnerWendy Turner
    May 14, 2014 at 12:26 am
    May 14, 2014 at 12:26 am
  • How big is your cluster? The number of nodes interacts with file size & number of files in another way. If there are more nodes than files, by definition some nodes will be idle, so the query can't ...
    John RussellJohn Russell
    May 7, 2014 at 11:55 pm
    May 7, 2014 at 11:55 pm
  • Hi Matt, It appears there may be an inconsistency in the cached Impala table metadata relative to the Hive Metastore. Perhaps a partition was added external to Impala? Try running "REFRESH <table ...
    Lenni KuffLenni Kuff
    May 6, 2014 at 7:13 pm
    May 6, 2014 at 7:13 pm
  • Hi, we are in impala 1.2.3 and are wondering how to list and kill long running queries from the impala shell. I see https://issues.cloudera.org/browse/IMPALA-237 has been fixed but, I don't see any ...
    Sukhendu chakrabortySukhendu chakraborty
    May 5, 2014 at 6:51 pm
    May 5, 2014 at 6:51 pm
  • The Impala interface to HDFS caching is targeting release either in this upcoming summer or fall release. To unsubscribe from this group and stop receiving emails from it, send an email to ...
    Justin EricksonJustin Erickson
    May 2, 2014 at 1:13 am
    May 2, 2014 at 1:13 am
  • Dear CDH, Cloudera Manager, and Cloudera Impala users, We are pleased to announce the general availability of Cloudera Impala 1.3.1 for use with CDH4. Impala 1.3.1 contains stability enhancements and ...
    Wendy TurnerWendy Turner
    May 1, 2014 at 7:16 pm
    May 1, 2014 at 7:16 pm
May 2014
Group Navigation
period‹ prev | May 2014 | next ›
Group Overview
groupimpala-user @
categorieshadoop
discussions42
posts147
users51
websitecloudera.com
irc#hadoop

51 users for May 2014

Sean O'Brien: 12 posts Abhi Basu: 11 posts Lenni Kuff: 11 posts Zesheng Wu: 9 posts Matthew Jacobs: 7 posts Nong Li: 7 posts Pengcheng Liu: 7 posts Shrinath Parikh: 6 posts Tivona Hu: 5 posts Toni Cebrián: 4 posts Gaurav: 3 posts Gvr.deepak: 3 posts John Russell: 3 posts Mahesh G: 3 posts Marcel Kornacker: 3 posts Yoni Darash: 3 posts Chas: 2 posts : 2 posts Alan Choi: 2 posts Amit Dutta: 2 posts
show more
Archives