FAQ
Yes this is in Hue. This feature has been in Hue since the first version of
the app (here it is a Hive screenshot, but this is the same for Impala):

Romain

[image: Inline image 1]



On Mon, Jul 15, 2013 at 10:19 PM, nancy jean wrote:

So you are saying that this parameterization setting is in Hue? Is it
available now or is it in the roadmap?

On Monday, July 15, 2013 8:59:10 PM UTC+5:30, Romain wrote:

If you are using the Hue interface (e.g. http://player.vimeo.com/video/**
64825639#t=2m40s <http://player.vimeo.com/video/64825639#t=2m40s>) for
sending queries to Impala, you can parametrize it by inserting some
$my_param1, $my_param2... and be prompted for the values at submission time.

Romain

On Mon, Jul 15, 2013 at 4:01 AM, nancy jean wrote:

Hi, I happen to find a link in cloudera site saying that, there is some
setting for parameterization.
Can you explain what that is?

http://www.cloudera.com/**content/cloudera-content/**
cloudera-docs/CDH4/4.2.0/Hue-**2-User-Guide/hue23.html<http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/Hue-2-User-Guide/hue23.html>

On Tuesday, July 9, 2013 11:41:35 PM UTC+5:30, Alan wrote:

Hi Darko,

It seems like the concept of "parameterized query" belongs Pentaho.
Impala doesn't have this concept. I think you might get a better answer
from the Pentaho forum?

Thanks,
Alan

On Mon, Jul 8, 2013 at 4:16 AM, Darko Lugomer wrote:

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 on top of Hadoop
because the query response time was very poor (we're talking couple of
minutes for 2 quite small tables). That's why we decided to use Impala.
Anyway, when I create a static query I get results back, but when I
parametrize the query I get error.. I know that Pentaho takes it's
parameters like: ${} , but it doesn't seem to work. That is when I work
with Report Designer. In CDE I simply get error processing component.. In
one word: heeeeeellllppppp...

Tnx!
Darko

Search Discussions

  • Nancy jean at Jul 16, 2013 at 6:36 am
    OK. Thank you..
    On Tuesday, July 16, 2013 11:47:00 AM UTC+5:30, Romain wrote:

    Yes this is in Hue. This feature has been in Hue since the first version
    of the app (here it is a Hive screenshot, but this is the same for Impala):

    Romain

    [image: Inline image 1]




    On Mon, Jul 15, 2013 at 10:19 PM, nancy jean <nancyj...@gmail.com<javascript:>
    wrote:
    So you are saying that this parameterization setting is in Hue? Is it
    available now or is it in the roadmap?

    On Monday, July 15, 2013 8:59:10 PM UTC+5:30, Romain wrote:

    If you are using the Hue interface (e.g. http://player.vimeo.com/video/*
    *64825639#t=2m40s <http://player.vimeo.com/video/64825639#t=2m40s>) for
    sending queries to Impala, you can parametrize it by inserting some
    $my_param1, $my_param2... and be prompted for the values at submission time.

    Romain

    On Mon, Jul 15, 2013 at 4:01 AM, nancy jean wrote:

    Hi, I happen to find a link in cloudera site saying that, there is some
    setting for parameterization.
    Can you explain what that is?

    http://www.cloudera.com/**content/cloudera-content/**
    cloudera-docs/CDH4/4.2.0/Hue-**2-User-Guide/hue23.html<http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/Hue-2-User-Guide/hue23.html>

    On Tuesday, July 9, 2013 11:41:35 PM UTC+5:30, Alan wrote:

    Hi Darko,

    It seems like the concept of "parameterized query" belongs Pentaho.
    Impala doesn't have this concept. I think you might get a better answer
    from the Pentaho forum?

    Thanks,
    Alan

    On Mon, Jul 8, 2013 at 4:16 AM, Darko Lugomer wrote:

    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 on top of Hadoop
    because the query response time was very poor (we're talking couple of
    minutes for 2 quite small tables). That's why we decided to use Impala.
    Anyway, when I create a static query I get results back, but when I
    parametrize the query I get error.. I know that Pentaho takes it's
    parameters like: ${} , but it doesn't seem to work. That is when I work
    with Report Designer. In CDE I simply get error processing component.. In
    one word: heeeeeellllppppp...

    Tnx!
    Darko
  • Pari Margu at Nov 25, 2013 at 5:15 pm
    i have installed instaview 5.0, try to connect impala and run the select
    query and try to visualize the data, it says impala query Order By should
    use LIMIT and it says method not supported. i am not able to visualize the
    data from impala data. please give me some inputs.
    On Tuesday, July 16, 2013 12:06:20 PM UTC+5:30, nancy jean wrote:

    OK. Thank you..
    On Tuesday, July 16, 2013 11:47:00 AM UTC+5:30, Romain wrote:

    Yes this is in Hue. This feature has been in Hue since the first version
    of the app (here it is a Hive screenshot, but this is the same for Impala):

    Romain

    [image: Inline image 1]



    On Mon, Jul 15, 2013 at 10:19 PM, nancy jean wrote:

    So you are saying that this parameterization setting is in Hue? Is it
    available now or is it in the roadmap?

    On Monday, July 15, 2013 8:59:10 PM UTC+5:30, Romain wrote:

    If you are using the Hue interface (e.g. http://player.vimeo.com/video/
    64825639#t=2m40s<http://www.google.com/url?q=http%3A%2F%2Fplayer.vimeo.com%2Fvideo%2F64825639%23t%3D2m40s&sa=D&sntz=1&usg=AFQjCNF-PDCC-cw3_iCu6TZOo2wFLBenQg>)
    for sending queries to Impala, you can parametrize it by inserting some
    $my_param1, $my_param2... and be prompted for the values at submission time.

    Romain

    On Mon, Jul 15, 2013 at 4:01 AM, nancy jean wrote:

    Hi, I happen to find a link in cloudera site saying that, there is
    some setting for parameterization.
    Can you explain what that is?

    http://www.cloudera.com/content/cloudera-content/
    cloudera-docs/CDH4/4.2.0/Hue-2-User-Guide/hue23.html<http://www.google.com/url?q=http%3A%2F%2Fwww.cloudera.com%2Fcontent%2Fcloudera-content%2Fcloudera-docs%2FCDH4%2F4.2.0%2FHue-2-User-Guide%2Fhue23.html&sa=D&sntz=1&usg=AFQjCNFCEPg_KprnHQSYbL1CnIuopcqq_Q>

    On Tuesday, July 9, 2013 11:41:35 PM UTC+5:30, Alan wrote:

    Hi Darko,

    It seems like the concept of "parameterized query" belongs Pentaho.
    Impala doesn't have this concept. I think you might get a better answer
    from the Pentaho forum?

    Thanks,
    Alan

    On Mon, Jul 8, 2013 at 4:16 AM, Darko Lugomer wrote:

    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 on top of Hadoop
    because the query response time was very poor (we're talking couple of
    minutes for 2 quite small tables). That's why we decided to use Impala.
    Anyway, when I create a static query I get results back, but when I
    parametrize the query I get error.. I know that Pentaho takes it's
    parameters like: ${} , but it doesn't seem to work. That is when I work
    with Report Designer. In CDE I simply get error processing component.. In
    one word: heeeeeellllppppp...

    Tnx!
    Darko
    To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouphue-user @
categorieshadoop
postedJul 16, '13 at 6:17a
activeNov 25, '13 at 5:15p
posts3
users3
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase