[jira] Commented: (HADOOP-2595) [HQL] Outputting select into file

["stack (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HADOOP-2595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12558863#action_12558863 ] 

stack commented on HADOOP-2595:
-------------------------------

You think this the way to go Edward?  Don't you want to specify a format for the output file (html|txt|binary|etc).  You added formatting as command-line option to the shell... making it so you could do: "$ echo 'SELECT * FROM ... '| ./bin/hbase shell --format=SOME_FORMAT > outputfile'.  Isn't that sufficient? (How does mysql do this?  Or how does mysql read into current mysql shell a list of commands to run?  I don't remember ...)

> [HQL] Outputting select into file
> ---------------------------------
>
>                 Key: HADOOP-2595
>                 URL: https://issues.apache.org/jira/browse/HADOOP-2595
>             Project: Hadoop
>          Issue Type: New Feature
>          Components: contrib/hbase
>    Affects Versions: 0.16.0
>            Reporter: Edward Yoon
>            Assignee: Edward Yoon
>            Priority: Minor
>             Fix For: 0.17.0
>
>
> {code}
> SELECT { column_name [, column_name] ... | expr[alias] | * }
>     FROM table_name
>     [WHERE row = 'row-key' | STARTING FROM 'row-key' [UNTIL 'stop-key']]
>     [NUM_VERSIONS = version_count]
>     [TIMESTAMP 'timestamp']
>     [LIMIT = row_count]
>     [INTO FILE 'file_name']                                 <----------------*
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.