Mailing-List: contact hdfs-issues-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Date: Thu, 24 Aug 2017 22:32:00 +0000 (UTC)
From: "Chen Liang (JIRA)" <jira@apache.org>
To: hdfs-issues@hadoop.apache.org
Message-ID: <JIRA.13096125.1503087082000.116448.1503613920102@Atlassian.JIRA>
In-Reply-To: <JIRA.13096125.1503087082000@Atlassian.JIRA>
References: <JIRA.13096125.1503087082000@Atlassian.JIRA> <JIRA.13096125.1503087082454@jira-lw-us.apache.org>
Subject: [jira] [Updated] (HDFS-12321) Ozone : debug cli: add support to
 load user-provided SQL query
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 24 Aug 2017 22:32:05 -0000


     [ 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:
{{listSkipping}}
{{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
(v6.4.14#64029)

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