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/12 04:58:00 UTC
[jira] [Created] (ASTERIXDB-2629) Unclear error message for ADM
external data with invalid types
Nick DiGeronimo created ASTERIXDB-2629:
------------------------------------------
Summary: 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
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".}}
{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]
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)