drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3253) Add test/mock storage plugin providing columns of all data types for testing metadata (etc.)
Date Fri, 17 Jul 2015 23:03:05 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14632080#comment-14632080
] 

Jacques Nadeau commented on DRILL-3253:
---------------------------------------

Please note, there is already a MockStorageEngine.  It sounds like you'd like to extend this
for SQL purposes.  Alternatively, you could use the VALUES operator.  For example:

{code}
SELECT * FROM (VALUES (1, 2), (3, 4), (5, 6), (7, 8), (9, 10) ) AS MyTable(a, b);
{code}

> Add test/mock storage plugin providing columns of all data types for testing metadata
(etc.)
> --------------------------------------------------------------------------------------------
>
>                 Key: DRILL-3253
>                 URL: https://issues.apache.org/jira/browse/DRILL-3253
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC, Storage - Information Schema, Tools, Build &
Test
>            Reporter: Daniel Barclay (Drill)
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.2.0
>
>
> There probably should be a test/dummy/mock storage plugin that provides an easy way to
have views and/or tables with columns covering all* supported data types.
> (*for appropriate values of "all"--all top-level cases (atomic types (e.g., INTEGER,
VARCHAR(...))); some, but obviously not all, subcases (e.g., VARCHAR(1) vs. VARCHAR(2), INTEGER
ARRAY vs. INTEGER ARRAY ARRAY)).
> This would allow more-complete and/or easier testing of things such as INFORMATION_SCHEMA.COLUMNS
and DatabaseMetaData.getColumns(...).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message