You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Nick DiGeronimo (JIRA)" <ji...@apache.org> on 2019/08/13 22:41:00 UTC
[jira] [Updated] (ASTERIXDB-2629) Unclear error message for ADM
external data with invalid types
[ https://issues.apache.org/jira/browse/ASTERIXDB-2629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nick DiGeronimo updated ASTERIXDB-2629:
---------------------------------------
Description:
AsterixDB gives an unhelpful error message when loading in ADM data with mismatching types. Try the example below using the attached "dirtyAdm.jsonl".
DROP DATASET TestDataset;
DROP TYPE TestType;
CREATE TYPE TestType AS open {
testId: uuid
}
CREATE DATASET TestDataset(TestType) PRIMARY KEY testId AUTOGENERATED;
LOAD DATASET TestDataset USING localfs
(("path"=":///Users/macandcheese/Desktop/dirtyAdm.jsonl"),("format"="adm"));
SELECT * FROM TestDataset;
To run this, create a file "dirtyAdm.jsonl" with these contents:
{"expectedInteger": double("23.4")}
was:
{{AsterixDB gives an unhelpful error message when loading in ADM data with mismatching types. Try the example below using the attached "dirtyAdm.jsonl".}}
{quote}{{DROP DATASET TestDataset;
DROP TYPE TestType;
CREATE TYPE TestType AS open {
testId: uuid,
expectedInteger: bigint
};
CREATE DATASET TestDataset(TestType) PRIMARY KEY testId AUTOGENERATED;
LOAD DATASET TestDataset USING localfs
(("path"=":///Users/macandcheese/Desktop/dirtyAdm.jsonl"),("format"="adm"));
SELECT * FROM TestDataset;}}
{quote}
Alternatively, create a file manually with these contents:
{quote}{"expectedInteger": double("23.4")}
{quote}
Attached file: [^dirtyAdm.jsonl]
> Unclear error message for ADM external data with invalid types
> --------------------------------------------------------------
>
> Key: ASTERIXDB-2629
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2629
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: *DB - AsterixDB
> Reporter: Nick DiGeronimo
> Priority: Minor
> Attachments: dirtyAdm.jsonl
>
>
> AsterixDB gives an unhelpful error message when loading in ADM data with mismatching types. Try the example below using the attached "dirtyAdm.jsonl".
> DROP DATASET TestDataset;
> DROP TYPE TestType;
> CREATE TYPE TestType AS open {
> testId: uuid
> }
> CREATE DATASET TestDataset(TestType) PRIMARY KEY testId AUTOGENERATED;
> LOAD DATASET TestDataset USING localfs
> (("path"=":///Users/macandcheese/Desktop/dirtyAdm.jsonl"),("format"="adm"));
> SELECT * FROM TestDataset;
> To run this, create a file "dirtyAdm.jsonl" with these contents:
> {"expectedInteger": double("23.4")}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)