FAQ
I am getting an error when i do this:

[root@ssbox3 hive_impala]# impala-shell -c ssbox3:21000 -q "select * from
ucef_flume_full limit 10" > results.txt
Usage: impala_shell.py [options]

impala_shell.py: error: no such option: -c

Any thoughts?

Thanks!
-Alan
On Monday, January 7, 2013 9:29:50 PM UTC-5, Henry wrote:

(+impala-user)

Hi -

You can save the results of a query by piping the output to a file, like
so:

impala-shell -c localhost:21000 -q "select * from mytable" > results.txt

Hope this helps,
Henry

On 7 January 2013 18:27, Yang Damon <Damon...@nielsenccdata.com<javascript:>
wrote:
Hi Henry****

This question, I got answer from impala_shell.py , such as:****

parser*.*add_option("-q", "--query", dest*=*"query", default*=*None,****

help*=*"Execute a query without the shell")****

** **

But I have another question :****

How to save the results in a local file system ?****

Thank you !****

** **

** **

*Damon Yang*

*仰宗昭***

** **

*发件人:* Henry Robinson [mailto:he...@cloudera.com <javascript:>]
*发送时间:* 2013年1月8日 3:27
*收件人:* impal...@cloudera.org <javascript:>
*抄送:* Yang Damon
*主题:* Re: about impala-shell options****

** **

Hi Damon - ****

** **

I think we might be missing a bit of question context here - what would
you like to know about the Impala shell?****

** **

Best,****

Henry****

On 7 January 2013 10:31, Romain Rigaux <rom...@cloudera.com <javascript:>>
wrote:****

+impala-user****

On Mon, Jan 7, 2013 at 1:42 AM, Yang Damon <Damon...@nielsenccdata.com<javascript:>>
wrote:****

Hi romain,****

What about impala-shell options, such as �CI �Cf ;****

Thank you so much****

****

*Damon Yang*****

*仰宗昭*****

****

** **

--

****



****

** **

--
Henry Robinson
Software Engineer
Cloudera
415-994-6679 ****


--
Henry Robinson
Software Engineer
Cloudera
415-994-6679
--

Search Discussions

  • Ricky Saltzer at Jan 18, 2013 at 10:40 pm
    Hi Alan -

    You should use the *-i *option when specifying a server.

    try
    $ impala-shell -i ssbox3:21000 -q "select * from ucef_flume_full limit 10"
    results.txt
    On Fri, Jan 18, 2013 at 5:37 PM, Alan Papir wrote:

    I am getting an error when i do this:

    [root@ssbox3 hive_impala]# impala-shell -c ssbox3:21000 -q "select * from
    ucef_flume_full limit 10" > results.txt
    Usage: impala_shell.py [options]

    impala_shell.py: error: no such option: -c

    Any thoughts?

    Thanks!
    -Alan
    On Monday, January 7, 2013 9:29:50 PM UTC-5, Henry wrote:

    (+impala-user)

    Hi -

    You can save the results of a query by piping the output to a file, like
    so:

    impala-shell -c localhost:21000 -q "select * from mytable" > results.txt

    Hope this helps,
    Henry
    On 7 January 2013 18:27, Yang Damon wrote:

    Hi Henry****

    This question, I got answer from impala_shell.py , such as:****

    parser*.*add_option("-q", "--query", dest*=*"query", default*=*None,****

    help*=*"**Execute a query without the shell")****

    ** **

    But I have another question :****

    How to save the results in a local file system ?****

    Thank you !****

    ** **

    ** **

    *Damon Yang*

    *仰宗昭***

    ** **

    *发件人:* Henry Robinson
    *发送时间:* 2013年1月8日 3:27
    *收件人:* impal...@cloudera.org
    *抄送:* Yang Damon
    *主题:* Re: about impala-shell options****

    ** **

    Hi Damon - ****

    ** **

    I think we might be missing a bit of question context here - what would
    you like to know about the Impala shell?****

    ** **

    Best,****

    Henry****

    On 7 January 2013 10:31, Romain Rigaux wrote:****

    +impala-user****

    On Mon, Jan 7, 2013 at 1:42 AM, Yang Damon <Damon...@nielsenccdata.com>
    wrote:****

    Hi romain,****

    What about impala-shell options, such as �CI �Cf ;****

    Thank you so much****

    ****

    *Damon Yang*****

    *仰宗昭*****

    ****

    ** **

    --

    ****



    ****

    ** **

    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679 ****


    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679
    --



    --

    --
  • Ishaan Joshi at Jan 18, 2013 at 10:40 pm
    Alan,

    That was a typo, the relevant command line option for specifying an
    impalad to connect to is -i or --impalad.
    impala-shell -i ssbox3:21000 -q "select * from ucef_flume_full limit
    10" > results.txt
    should work.

    Additionally, try out impala-shell --help to get a list of all the
    command line options.

    Thanks,

    .. Ishaan

    On Fri, Jan 18, 2013 at 2:37 PM, Alan Papir wrote:

    I am getting an error when i do this:

    [root@ssbox3 hive_impala]# impala-shell -c ssbox3:21000 -q "select * from
    ucef_flume_full limit 10" > results.txt
    Usage: impala_shell.py [options]

    impala_shell.py: error: no such option: -c

    Any thoughts?

    Thanks!
    -Alan
    On Monday, January 7, 2013 9:29:50 PM UTC-5, Henry wrote:

    (+impala-user)

    Hi -

    You can save the results of a query by piping the output to a file, like
    so:

    impala-shell -c localhost:21000 -q "select * from mytable" > results.txt

    Hope this helps,
    Henry
    On 7 January 2013 18:27, Yang Damon wrote:

    Hi Henry****

    This question, I got answer from impala_shell.py , such as:****

    parser*.*add_option("-q", "--query", dest*=*"query", default*=*None,****

    help*=*"**Execute a query without the shell")****

    ** **

    But I have another question :****

    How to save the results in a local file system ?****

    Thank you !****

    ** **

    ** **

    *Damon Yang*

    *仰宗昭***

    ** **

    *发件人:* Henry Robinson
    *发送时间:* 2013年1月8日 3:27
    *收件人:* impal...@cloudera.org
    *抄送:* Yang Damon
    *主题:* Re: about impala-shell options****

    ** **

    Hi Damon - ****

    ** **

    I think we might be missing a bit of question context here - what would
    you like to know about the Impala shell?****

    ** **

    Best,****

    Henry****

    On 7 January 2013 10:31, Romain Rigaux wrote:****

    +impala-user****

    On Mon, Jan 7, 2013 at 1:42 AM, Yang Damon <Damon...@nielsenccdata.com>
    wrote:****

    Hi romain,****

    What about impala-shell options, such as �CI �Cf ;****

    Thank you so much****

    ****

    *Damon Yang*****

    *仰宗昭*****

    ****

    ** **

    --

    ****



    ****

    ** **

    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679 ****


    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679
    --

    --
  • Henry Robinson at Jan 18, 2013 at 10:41 pm
    Hi Alan -

    I made a typo - the option you want is -i, not -c.

    Thanks,
    Henry
    On 18 January 2013 22:37, Alan Papir wrote:

    I am getting an error when i do this:

    [root@ssbox3 hive_impala]# impala-shell -c ssbox3:21000 -q "select * from
    ucef_flume_full limit 10" > results.txt
    Usage: impala_shell.py [options]

    impala_shell.py: error: no such option: -c

    Any thoughts?

    Thanks!
    -Alan
    On Monday, January 7, 2013 9:29:50 PM UTC-5, Henry wrote:

    (+impala-user)

    Hi -

    You can save the results of a query by piping the output to a file, like
    so:

    impala-shell -c localhost:21000 -q "select * from mytable" > results.txt

    Hope this helps,
    Henry
    On 7 January 2013 18:27, Yang Damon wrote:

    Hi Henry****

    This question, I got answer from impala_shell.py , such as:****

    parser*.*add_option("-q", "--query", dest*=*"query", default*=*None,****

    help*=*"**Execute a query without the shell")****

    ** **

    But I have another question :****

    How to save the results in a local file system ?****

    Thank you !****

    ** **

    ** **

    *Damon Yang*

    *仰宗昭***

    ** **

    *发件人:* Henry Robinson
    *发送时间:* 2013年1月8日 3:27
    *收件人:* impal...@cloudera.org
    *抄送:* Yang Damon
    *主题:* Re: about impala-shell options****

    ** **

    Hi Damon - ****

    ** **

    I think we might be missing a bit of question context here - what would
    you like to know about the Impala shell?****

    ** **

    Best,****

    Henry****

    On 7 January 2013 10:31, Romain Rigaux wrote:****

    +impala-user****

    On Mon, Jan 7, 2013 at 1:42 AM, Yang Damon <Damon...@nielsenccdata.com>
    wrote:****

    Hi romain,****

    What about impala-shell options, such as �CI �Cf ;****

    Thank you so much****

    ****

    *Damon Yang*****

    *仰宗昭*****

    ****

    ** **

    --

    ****



    ****

    ** **

    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679 ****


    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679
    --



    --
    Henry Robinson
    Software Engineer
    Cloudera
    415-994-6679

    --

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedJan 18, '13 at 10:37p
activeJan 18, '13 at 10:41p
posts4
users4
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase