[jira] [Commented] (ASTERIXDB-1667) Error during ingestion from JSON data file

[Subhasis (JIRA)]

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

Subhasis commented on ASTERIXDB-1667:
-------------------------------------

create dataverse newsPaper;
use dataverse newsPaper;

 create type newspaperType if not exists as open{
        articleId: string,
        title: string,
        PublicationDate: int64?,
        location: [int32]?,
        commercial: boolean?,
        localgov: boolean?,
        circulationLevel: string?,
        Start: int64,
        end: int64
    };
    
    create type authorType if not exists as open{
       name: string?, 
       specialty: string?
       
       
    };
    
    
    create type newsType if not exists as open{
        articleId: string,
        title: string,
        PublicationDate: int64?,
        newsPaperType: newspaperType,
        authorType: authorType?,
        keywords: [string]?,
        Place: [string]?,
        OrganisationType: [string]?,
        peopleMentioned: [string]?,
        newssection : string?,
        imageURL : string?,
        videoURL : string?, 
        pageNumber : string,
        page : string,
        file : string, 
        content : string
         };
    
    create dataset news (newsType)
    primary key articleId;
    
    
 use dataverse newsPaper;   
   create feed newsFeed using localfs
 (("path"="127.0.01:///Users/subhasis/Documents/dataTest/"),
 ("format"="adm"), ("type-name"="newsType"),("expression"=".*\\.adm"));
 
 use dataverse newsPaper;
 connect feed newsFeed to dataset news;

> Error during ingestion from JSON data file 
> -------------------------------------------
>
>                 Key: ASTERIXDB-1667
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1667
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Adapters, AsterixDB
>         Environment: MAC and Eclipse 
>            Reporter: Subhasis
>              Labels: github-import
>
> I have found the following error while I was trying to load some JSON data : 
> insert into dataset news  ( for $x in feed-collect 
> ('newsPaper','newsFeed','newsFeed','INTAKE','news','newsType') return $x);
> Exception in thread "pool-2-thread-1" java.lang.NoClassDefFoundError: Could 
> not initialize class org.apache.asterix.translator.util.FunctionCollection
>       at 
> org.apache.asterix.translator.LangExpressionToPlanTranslator.<init>(LangExpressionToPlanTranslator.java:182)
>       at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslator.<init>(AqlExpressionToPlanTranslator.java:69)
>       at 
> org.apache.asterix.translator.AqlExpressionToPlanTranslatorFactory.createExpressionToPlanTranslator(AqlExpressionToPlanTranslatorFactory.java:31)
>       at 
> org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:220)
>       at 
> org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1958)
>       at 
> org.apache.asterix.app.translator.QueryTranslator.handleSubscribeFeedStatement(QueryTranslator.java:2408)
>       at 
> org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:367)
>       at 
> org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:268)
>       at 
> org.apache.asterix.app.external.FeedWorkCollection$SubscribeFeedWork$SubscribeFeedWorkRunnable.run(FeedWorkCollection.java:95)
>       at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>       at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>       at java.lang.Thread.run(Thread.java:745)
> I am attaching my data and the aql scripts 



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