I solved this one, SET PARSER csv SET CSVPARSER encoding=utf-8, header=true, separator=comma SET CREATEFILTER *.csv
But now with 16565274 rows csv file, 690M. During indexing, I am getting this. I have set memory to 30G Creating Database... java.lang.NegativeArraySizeException at java.util.Arrays.copyOf(Arrays.java:2271) at org.basex.util.TokenBuilder.addByte(TokenBuilder.java:242) at org.basex.util.TokenBuilder.add(TokenBuilder.java:151) at org.basex.io.parse.XmlTokenBuilder.add(XmlTokenBuilder.java:96) at org.basex.io.parse.XmlTokenBuilder.addText(XmlTokenBuilder.java:51) at org.basex.io.parse.csv.CsvStringConverter.entry(CsvStringConverter.java:76) at org.basex.io.parse.csv.CsvParser.record(CsvParser.java:105) at org.basex.io.parse.csv.CsvParser.parse(CsvParser.java:80) at org.basex.io.parse.csv.CsvParser.parse(CsvParser.java:54) at org.basex.io.parse.csv.CsvConverter.convert(CsvConverter.java:37) at org.basex.build.CsvParser.toXML(CsvParser.java:40) On Wed, Jan 7, 2015 at 9:30 PM, Erol Akarsu <eaka...@gmail.com> wrote: > > I am trying to index an csv file through basexclient. I issued this command > > SET INTPARSE false; CREATE DB Properties Properties.csv > > got these error message in basex server. What shall I do to index csv > through basexclient command? > > > [kangadm@kangapp12 javaProcess]$ basexserver -d > BaseX 7.9 [Server] > Server was started (port: 1984) > Creating Database... > org.xml.sax.SAXParseException; systemId: > file:///home/kangadm/basex/migros/production/javaProcess/Brands.sql.csv; > lineNumber: 1; columnNumber: 1; Content is not allowed in prolog. > at > com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:198) > at > com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177) > at > com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:441) > at > com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:368) > at > com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1436) > >