hadoop-hdfs-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chen Liang (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HDFS-12321) Ozone : debug cli: add support to load user-provided SQL query
Date Thu, 24 Aug 2017 22:32:00 GMT

     [ https://issues.apache.org/jira/browse/HDFS-12321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Chen Liang updated HDFS-12321:
    Attachment: HDFS-12321-HDFS-7240.008.patch

[~anu] submit v008 patch based on your v007 patch. Now it works like:

in json we specify something like:
{{select * from volumeInfo where volumeName like :A: and userName != :B:;}}
and CLI recognize it as having two arguments, A at position#1, and B at position#2.

then from command one can do:
{{hdfs ozsqlquery --listSkipping B=userName A=volume123  -o out -p in.db}}
then the parser takes an argument list of B=userName A=volume123 (yes, A and B can be out
of order). And map it as position A = position#1 = volume123, B = position#2 = userName, and
insert into the SQL query.

> Ozone : debug cli: add support to load user-provided SQL query
> --------------------------------------------------------------
>                 Key: HDFS-12321
>                 URL: https://issues.apache.org/jira/browse/HDFS-12321
>             Project: Hadoop HDFS
>          Issue Type: Sub-task
>            Reporter: Chen Liang
>            Assignee: Chen Liang
>             Fix For: ozone
>         Attachments: HDFS-12321-HDFS-7240.001.patch, HDFS-12321-HDFS-7240.002.patch,
HDFS-12321-HDFS-7240.003.patch, HDFS-12321-HDFS-7240.004.patch, HDFS-12321-HDFS-7240.005.patch,
HDFS-12321-HDFS-7240.006.patch, HDFS-12321-HDFS-7240.007.patch, HDFS-12321-HDFS-7240.008.patch
> This JIRA extends SQL CLI to support loading a user-provided file that includes any sql
query the user wants to run on the SQLite db obtained by converting Ozone metadata db.

This message was sent by Atlassian JIRA

To unsubscribe, e-mail: hdfs-issues-unsubscribe@hadoop.apache.org
For additional commands, e-mail: hdfs-issues-help@hadoop.apache.org

View raw message