[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92760541 --- Diff: processing/src/main/java/org/apache/carbondata/processing/newflow/converter/impl/RowConverterImpl.java --- @@ -73,10 +79,39 @@ public void initialize() { long lruCacheStartTime = System.currentTimeMillis(); +// for one pass load, start the dictionary client +if (configuration.getUseOnePass()) { + executorService = Executors.newFixedThreadPool(1); + Future result = executorService.submit(new Callable() { +@Override +public DictionaryClient call() throws Exception { + Thread.currentThread().setName("Dictionary client"); + DictionaryClient dictionaryClient = new DictionaryClient(); + dictionaryClient.startClient(configuration.getDictionaryServerHost(), + configuration.getDictionaryServerPort()); + return dictionaryClient; +} + }); + + try { +Thread.sleep(1000); --- End diff -- Why sleep 1 second? please add comment --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92760381 --- Diff: integration/spark/src/test/scala/org/apache/carbondata/spark/testsuite/dataload/TestLoadDataUseOnePass.scala --- @@ -0,0 +1,75 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +package org.apache.carbondata.spark.testsuite.dataload + +import org.apache.spark.sql.common.util.CarbonHiveContext._ +import org.apache.spark.sql.common.util.QueryTest +import org.scalatest.BeforeAndAfterAll + +/** + * Test Class for data loading use one pass + * + */ +class TestLoadDataUseOnePass extends QueryTest with BeforeAndAfterAll { + + override def beforeAll { +sql("DROP TABLE IF EXISTS table_two_pass") +sql("DROP TABLE IF EXISTS table_one_pass") + +sql( + """ +|CREATE TABLE table_two_pass (ID int, date Timestamp, country String, +|name String, phonetype String, serialname String, salary int) +|STORED BY 'org.apache.carbondata.format' + """.stripMargin) + +sql( + """ +|LOAD DATA local inpath './src/test/resources/dataDiff.csv' INTO TABLE table_two_pass +|OPTIONS('DELIMITER'= ',', 'USE_KETTLE'='false', 'USE_ONEPASS'='false') --- End diff -- change option name from USE_ONEPASS to SINGLE_PASS --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92760320 --- Diff: core/src/main/java/org/apache/carbondata/core/dictionary/server/DictionaryServerHandler.java --- @@ -0,0 +1,75 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ +package org.apache.carbondata.core.dictionary.server; + +import org.apache.carbondata.core.dictionary.generator.DictionaryGeneratorForServer; +import org.apache.carbondata.core.dictionary.generator.key.DictionaryKey; + +import com.alibaba.fastjson.JSON; + +import org.jboss.netty.channel.*; + + +/** + * Handler for Dictionary server. + */ +public class DictionaryServerHandler extends SimpleChannelHandler { + + private DictionaryGeneratorForServer generatorForServer = new DictionaryGeneratorForServer(); + + public void channelConnected(ChannelHandlerContext ctx, ChannelStateEvent e) throws Exception { --- End diff -- Add description to all functions in this class --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92760025 --- Diff: core/src/main/java/org/apache/carbondata/core/dictionary/generator/TableDictionaryGenerator.java --- @@ -0,0 +1,110 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ +package org.apache.carbondata.core.dictionary.generator; + +import java.util.ArrayList; +import java.util.List; +import java.util.Map; +import java.util.concurrent.*; + +import org.apache.carbondata.common.logging.LogService; +import org.apache.carbondata.common.logging.LogServiceFactory; +import org.apache.carbondata.core.carbon.metadata.CarbonMetadata; +import org.apache.carbondata.core.carbon.metadata.schema.table.CarbonTable; +import org.apache.carbondata.core.carbon.metadata.schema.table.column.CarbonDimension; +import org.apache.carbondata.core.constants.CarbonCommonConstants; +import org.apache.carbondata.core.devapi.BiDictionary; +import org.apache.carbondata.core.devapi.DictionaryGenerationException; +import org.apache.carbondata.core.devapi.DictionaryGenerator; +import org.apache.carbondata.core.dictionary.generator.key.DictionaryKey; +import org.apache.carbondata.core.util.CarbonProperties; + +/** + * Dictionary generation for table. + */ +public class TableDictionaryGenerator +implements DictionaryGenerator, DictionaryWriter { + + private static final LogService LOGGER = + LogServiceFactory.getLogService(TableDictionaryGenerator.class.getName()); + + private Map> columnMap = new ConcurrentHashMap<>(); --- End diff -- What is the key and value of this map, please add description. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92760062 --- Diff: core/src/main/java/org/apache/carbondata/core/dictionary/generator/key/DictionaryKey.java --- @@ -0,0 +1,77 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ +package org.apache.carbondata.core.dictionary.generator.key; + + +/** + * Dictionary key to generate dictionary + */ +public class DictionaryKey { + + private String tableUniqueName; + + private String columnName; + + private Object data; + + private String type; + + private String threadNo; + + --- End diff -- remove empty line --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92759585 --- Diff: core/src/main/java/org/apache/carbondata/core/dictionary/generator/DictionaryGeneratorForServer.java --- @@ -0,0 +1,71 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ +package org.apache.carbondata.core.dictionary.generator; + +import java.util.Map; +import java.util.concurrent.ConcurrentHashMap; + +import org.apache.carbondata.core.carbon.metadata.CarbonMetadata; +import org.apache.carbondata.core.carbon.metadata.schema.table.CarbonTable; +import org.apache.carbondata.core.carbon.metadata.schema.table.column.CarbonDimension; +import org.apache.carbondata.core.devapi.DictionaryGenerationException; +import org.apache.carbondata.core.devapi.DictionaryGenerator; +import org.apache.carbondata.core.dictionary.generator.key.DictionaryKey; + +/** + * This is the dictionary generator for all tables. It generates dictionary + * based on @{@link DictionaryKey}. + */ +public class DictionaryGeneratorForServer implements DictionaryGenerator { --- End diff -- Please give a proper name for this generator, one way is to describe how it generates Dictionary. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92759176 --- Diff: core/src/main/java/org/apache/carbondata/core/dictionary/client/DictionaryClientHandler.java --- @@ -0,0 +1,103 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ +package org.apache.carbondata.core.dictionary.client; + +import java.util.Map; +import java.util.concurrent.BlockingQueue; +import java.util.concurrent.ConcurrentHashMap; +import java.util.concurrent.LinkedBlockingQueue; + +import org.apache.carbondata.core.dictionary.generator.key.DictionaryKey; + +import com.alibaba.fastjson.JSON; + +import org.jboss.netty.channel.*; + +/** + * Client handler to get data. + */ +public class DictionaryClientHandler extends SimpleChannelHandler { + + final Map> dictKeyQueueMap = new ConcurrentHashMap<>(); + + private ChannelHandlerContext ctx; + + private Object lock = new Object(); + + @Override + public void channelConnected(ChannelHandlerContext ctx, ChannelStateEvent e) throws Exception { +this.ctx = ctx; +System.out.println("Connected " + ctx.getHandler()); +super.channelConnected(ctx, e); + } + + @Override + public void messageReceived(ChannelHandlerContext ctx, MessageEvent e) throws Exception { +String backkeyString = (String) e.getMessage(); +DictionaryKey key = JSON.parseObject(backkeyString, DictionaryKey.class); +BlockingQueue dictKeyQueue = dictKeyQueueMap.get(key.getThreadNo()); +dictKeyQueue.offer(key); +super.messageReceived(ctx, e); + } + + @Override + public void exceptionCaught(ChannelHandlerContext ctx, ExceptionEvent e) throws Exception { +System.out.println("exceptionCaught"); +ctx.getChannel().close(); + } + + /** + * client send request to server + * + * @param key + * @return + */ + public DictionaryKey getDictionary(DictionaryKey key) { +DictionaryKey dictionaryKey; +BlockingQueue dictKeyQueue = null; +try { + synchronized (lock) { +dictKeyQueue = dictKeyQueueMap.get(key.getThreadNo()); +if (dictKeyQueue == null) { + dictKeyQueue = new LinkedBlockingQueue(); + dictKeyQueueMap.put(key.getThreadNo(), dictKeyQueue); +} + } + String keyString = JSON.toJSONString(key); + ctx.getChannel().write(keyString); +} catch (Exception e) { + e.printStackTrace(); +} +boolean interrupted = false; +try { + for (; ; ) { +try { + dictionaryKey = dictKeyQueue.take(); --- End diff -- Is there timeout option here, it is not good to do dead loop here --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92759097 --- Diff: core/src/main/java/org/apache/carbondata/core/dictionary/client/DictionaryClientHandler.java --- @@ -0,0 +1,103 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + *http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ +package org.apache.carbondata.core.dictionary.client; + +import java.util.Map; +import java.util.concurrent.BlockingQueue; +import java.util.concurrent.ConcurrentHashMap; +import java.util.concurrent.LinkedBlockingQueue; + +import org.apache.carbondata.core.dictionary.generator.key.DictionaryKey; + +import com.alibaba.fastjson.JSON; + +import org.jboss.netty.channel.*; + +/** + * Client handler to get data. + */ +public class DictionaryClientHandler extends SimpleChannelHandler { + + final Map> dictKeyQueueMap = new ConcurrentHashMap<>(); + + private ChannelHandlerContext ctx; + + private Object lock = new Object(); + + @Override + public void channelConnected(ChannelHandlerContext ctx, ChannelStateEvent e) throws Exception { +this.ctx = ctx; +System.out.println("Connected " + ctx.getHandler()); +super.channelConnected(ctx, e); + } + + @Override + public void messageReceived(ChannelHandlerContext ctx, MessageEvent e) throws Exception { +String backkeyString = (String) e.getMessage(); +DictionaryKey key = JSON.parseObject(backkeyString, DictionaryKey.class); +BlockingQueue dictKeyQueue = dictKeyQueueMap.get(key.getThreadNo()); +dictKeyQueue.offer(key); +super.messageReceived(ctx, e); + } + + @Override + public void exceptionCaught(ChannelHandlerContext ctx, ExceptionEvent e) throws Exception { +System.out.println("exceptionCaught"); +ctx.getChannel().close(); + } + + /** + * client send request to server + * + * @param key + * @return + */ + public DictionaryKey getDictionary(DictionaryKey key) { +DictionaryKey dictionaryKey; +BlockingQueue dictKeyQueue = null; +try { + synchronized (lock) { +dictKeyQueue = dictKeyQueueMap.get(key.getThreadNo()); +if (dictKeyQueue == null) { + dictKeyQueue = new LinkedBlockingQueue(); + dictKeyQueueMap.put(key.getThreadNo(), dictKeyQueue); +} + } + String keyString = JSON.toJSONString(key); + ctx.getChannel().write(keyString); +} catch (Exception e) { + e.printStackTrace(); --- End diff -- should use LOGGER --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #310: [CARBONDATA-401] One Pass Load
Github user jackylk commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/310#discussion_r92758681 --- Diff: core/src/main/java/org/apache/carbondata/core/carbon/metadata/schema/table/CarbonTable.java --- @@ -504,4 +521,19 @@ public void setBlockSizeInMB(int blockSize) { this.blockSize = blockSize; } + /** + * to get the all dimension of a table + * + * @param tableName + * @return all dimension of a table + */ + public CarbonDimension getAllDimensionByName(String tableName, String columnName) { --- End diff -- This function is not getting all dimensions, it is used for finding the specified column, right? I think there is already a function called `getDimensionByName` to provide this functionality --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #412: [CARBONDATA-519]Added vector reader in Carb...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/412 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/208/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #412: [CARBONDATA-519]Added vector reader in Carb...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/412 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/207/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #412: [CARBONDATA-519]Added vector reader ...
Github user ravipesala commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/412#discussion_r92744134 --- Diff: core/src/main/java/org/apache/carbondata/scan/executor/QueryExecutorFactory.java --- @@ -18,15 +18,69 @@ */ package org.apache.carbondata.scan.executor; +import java.util.List; + +import org.apache.carbondata.core.carbon.metadata.datatype.DataType; +import org.apache.carbondata.core.carbon.metadata.encoder.Encoding; import org.apache.carbondata.scan.executor.impl.DetailQueryExecutor; +import org.apache.carbondata.scan.executor.impl.VectorDetailQueryExecutor; +import org.apache.carbondata.scan.model.QueryDimension; +import org.apache.carbondata.scan.model.QueryMeasure; +import org.apache.carbondata.scan.model.QueryModel; +import org.apache.carbondata.scan.result.vector.CarbonColumnVector; +import org.apache.carbondata.scan.result.vector.CarbonColumnarBatch; +import org.apache.carbondata.scan.result.vector.impl.CarbonColumnVectorImpl; /** * Factory class to get the query executor from RDD * This will return the executor based on query type */ public class QueryExecutorFactory { - public static QueryExecutor getQueryExecutor() { -return new DetailQueryExecutor(); + public static QueryExecutor getQueryExecutor(QueryModel queryModel) { +if (queryModel.isVectorReader()) { + return new VectorDetailQueryExecutor(); +} else { + return new DetailQueryExecutor(); +} + } + + public static CarbonColumnarBatch createColuminarBatch(QueryModel queryModel) { +int batchSize = 1; +List queryDimension = queryModel.getQueryDimension(); +List queryMeasures = queryModel.getQueryMeasures(); +CarbonColumnVector[] vectors = +new CarbonColumnVector[queryDimension.size() + queryMeasures.size()]; +for (int i = 0; i < queryDimension.size(); i++) { + QueryDimension dim = queryDimension.get(i); + if (dim.getDimension().hasEncoding(Encoding.DIRECT_DICTIONARY)) { +vectors[dim.getQueryOrder()] = new CarbonColumnVectorImpl(batchSize, DataType.LONG); + } else if (!dim.getDimension().hasEncoding(Encoding.DICTIONARY)) { +vectors[dim.getQueryOrder()] = +new CarbonColumnVectorImpl(batchSize, dim.getDimension().getDataType()); + } else if (dim.getDimension().isComplex()) { +vectors[dim.getQueryOrder()] = new CarbonColumnVectorImpl(batchSize, DataType.STRUCT); + } else { +vectors[dim.getQueryOrder()] = new CarbonColumnVectorImpl(batchSize, DataType.INT); + } +} + +for (int i = 0; i < queryMeasures.size(); i++) { + QueryMeasure msr = queryMeasures.get(i); + switch (msr.getMeasure().getDataType()) { +case SHORT: +case INT: +case LONG: + vectors[msr.getQueryOrder()] = + new CarbonColumnVectorImpl(batchSize, msr.getMeasure().getDataType()); + break; +case DECIMAL: + vectors[msr.getQueryOrder()] = new CarbonColumnVectorImpl(batchSize, DataType.DECIMAL); + break; +default: + vectors[msr.getQueryOrder()] = new CarbonColumnVectorImpl(batchSize, DataType.DOUBLE); + } --- End diff -- No we can't use as we support few datatypes while storing reading measure data. Anyway this method is not used now, I am removing it --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #345: [CARBONDATA-443]Nosort dataloading
Github user QiangCai closed the pull request at: https://github.com/apache/incubator-carbondata/pull/345 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #345: [CARBONDATA-443]Nosort dataloading
Github user QiangCai commented on the issue: https://github.com/apache/incubator-carbondata/pull/345 Close this PR. In the future, I will raise another PR to support mixed data format table. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #412: [CARBONDATA-519]Added vector reader ...
Github user ravipesala commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/412#discussion_r92743691 --- Diff: core/src/main/java/org/apache/carbondata/scan/executor/QueryExecutorFactory.java --- @@ -18,15 +18,69 @@ */ package org.apache.carbondata.scan.executor; +import java.util.List; + +import org.apache.carbondata.core.carbon.metadata.datatype.DataType; +import org.apache.carbondata.core.carbon.metadata.encoder.Encoding; import org.apache.carbondata.scan.executor.impl.DetailQueryExecutor; +import org.apache.carbondata.scan.executor.impl.VectorDetailQueryExecutor; +import org.apache.carbondata.scan.model.QueryDimension; +import org.apache.carbondata.scan.model.QueryMeasure; +import org.apache.carbondata.scan.model.QueryModel; +import org.apache.carbondata.scan.result.vector.CarbonColumnVector; +import org.apache.carbondata.scan.result.vector.CarbonColumnarBatch; +import org.apache.carbondata.scan.result.vector.impl.CarbonColumnVectorImpl; /** * Factory class to get the query executor from RDD * This will return the executor based on query type */ public class QueryExecutorFactory { - public static QueryExecutor getQueryExecutor() { -return new DetailQueryExecutor(); + public static QueryExecutor getQueryExecutor(QueryModel queryModel) { +if (queryModel.isVectorReader()) { + return new VectorDetailQueryExecutor(); +} else { + return new DetailQueryExecutor(); +} + } + + public static CarbonColumnarBatch createColuminarBatch(QueryModel queryModel) { --- End diff -- This method is not used now, I am removing it --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #412: [CARBONDATA-519]Added vector reader ...
Github user ravipesala commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/412#discussion_r92743655 --- Diff: core/src/main/java/org/apache/carbondata/scan/executor/QueryExecutorFactory.java --- @@ -18,15 +18,69 @@ */ package org.apache.carbondata.scan.executor; +import java.util.List; + +import org.apache.carbondata.core.carbon.metadata.datatype.DataType; +import org.apache.carbondata.core.carbon.metadata.encoder.Encoding; import org.apache.carbondata.scan.executor.impl.DetailQueryExecutor; +import org.apache.carbondata.scan.executor.impl.VectorDetailQueryExecutor; +import org.apache.carbondata.scan.model.QueryDimension; +import org.apache.carbondata.scan.model.QueryMeasure; +import org.apache.carbondata.scan.model.QueryModel; +import org.apache.carbondata.scan.result.vector.CarbonColumnVector; +import org.apache.carbondata.scan.result.vector.CarbonColumnarBatch; +import org.apache.carbondata.scan.result.vector.impl.CarbonColumnVectorImpl; /** * Factory class to get the query executor from RDD * This will return the executor based on query type */ public class QueryExecutorFactory { - public static QueryExecutor getQueryExecutor() { -return new DetailQueryExecutor(); + public static QueryExecutor getQueryExecutor(QueryModel queryModel) { +if (queryModel.isVectorReader()) { + return new VectorDetailQueryExecutor(); +} else { + return new DetailQueryExecutor(); +} + } + + public static CarbonColumnarBatch createColuminarBatch(QueryModel queryModel) { +int batchSize = 1; --- End diff -- This method is not used now, I am removing it --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Resolved] (CARBONDATA-516) [SPARK2]update union class in CarbonLateDecoderRule for Spark 2.x integration
[ https://issues.apache.org/jira/browse/CARBONDATA-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacky Li resolved CARBONDATA-516. - Resolution: Fixed Fix Version/s: 1.0.0-incubating > [SPARK2]update union class in CarbonLateDecoderRule for Spark 2.x integration > - > > Key: CARBONDATA-516 > URL: https://issues.apache.org/jira/browse/CARBONDATA-516 > Project: CarbonData > Issue Type: New Feature >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 3h > Remaining Estimate: 0h > > In spark2, Union class is no longer sub-class of BinaryNode. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata pull request #412: [CARBONDATA-519]Added vector reader ...
Github user ravipesala commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/412#discussion_r92742973 --- Diff: integration/spark2/src/main/scala/org/apache/spark/sql/execution/CarbonLateDecodeStrategy.scala --- @@ -87,19 +90,17 @@ private[sql] class CarbonLateDecodeStrategy extends SparkStrategy { private[this] def toCatalystRDD( relation: LogicalRelation, output: Seq[Attribute], - rdd: RDD[Row], + rdd: RDD[InternalRow], needDecode: ArrayBuffer[AttributeReference]): RDD[InternalRow] = { -val newRdd = if (needDecode.size > 0) { +if (needDecode.size > 0) { + rdd.asInstanceOf[CarbonScanRDD].setVectorReaderSupport(false) getDecoderRDD(relation, needDecode, rdd, output) --- End diff -- if vector reader is true and `needDecode.size > 0` then it uses dictionary decoder rdd in its parent.But decoder rdd is not capable of handling columnar batches. I will raise another PR to move the decoder RDD logic to carbon layer. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #413: [CARBONDATA-516][SPARK2]fix union is...
Github user asfgit closed the pull request at: https://github.com/apache/incubator-carbondata/pull/413 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Updated] (CARBONDATA-516) [SPARK2]update union class in CarbonLateDecoderRule for Spark 2.x integration
[ https://issues.apache.org/jira/browse/CARBONDATA-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-516: - Summary: [SPARK2]update union class in CarbonLateDecoderRule for Spark 2.x integration (was: [SPARK2]update union issue in CarbonLateDecoderRule for Spark 2.x integration) > [SPARK2]update union class in CarbonLateDecoderRule for Spark 2.x integration > - > > Key: CARBONDATA-516 > URL: https://issues.apache.org/jira/browse/CARBONDATA-516 > Project: CarbonData > Issue Type: New Feature >Reporter: QiangCai >Assignee: QiangCai > Time Spent: 2h 50m > Remaining Estimate: 0h > > In spark2, Union class is no longer sub-class of BinaryNode. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-464) Frequent GC incurs when Carbon's blocklet size is enlarged from the default
[ https://issues.apache.org/jira/browse/CARBONDATA-464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-464: - Description: other columnar file format fetch 1 million(a row group) at a time, its data is divided into column chunks in columnar format, and each column trunk consists of many pages, the page(default size 1 MB) can be independently uncompressed and processed. In case of current carbon, since we use larger blocklet, it requires larger processing memory because it decompresses all projected column chunks within a blocklet all at once, which consumes big amount of memory in total. Maybe we should consider to come up with an alternative approach to balance I/O and processing, in order to reduce GC pressure. was: parquet might fetch from i/o 1 million(a row group) at one time, its data is divided into column chunks in columnar format, and each column trunk consists of many pages, the page(default size 1 MB) can be independently uncompressed and processed. In case of current carbon since we use larger blocklet, it requires larger processing memory as well, as it decompresses all projected column chunks within a blocklet, which consumes big amount of memory. Maybe we should consider to come up with similar approach to balance I/O and processing, but such a change requires carbon format level changes. Summary: Frequent GC incurs when Carbon's blocklet size is enlarged from the default (was: Big GC occurs frequently when Carbon's blocklet size is enlarged from the default) > Frequent GC incurs when Carbon's blocklet size is enlarged from the default > --- > > Key: CARBONDATA-464 > URL: https://issues.apache.org/jira/browse/CARBONDATA-464 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong > > other columnar file format fetch 1 million(a row group) at a time, its data > is divided into column chunks in columnar format, and each column trunk > consists of many pages, the page(default size 1 MB) can be independently > uncompressed and processed. > In case of current carbon, since we use larger blocklet, it requires larger > processing memory because it decompresses all projected column chunks within > a blocklet all at once, which consumes big amount of memory in total. Maybe > we should consider to come up with an alternative approach to balance I/O and > processing, in order to reduce GC pressure. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-437) Optimizing collectData in ScannedResultCollector
[ https://issues.apache.org/jira/browse/CARBONDATA-437?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-437: - Description: row assembly speed is slow compared to other columnar file format after file scan. (was: we compared the record assembly from memory when we already load data from hdfs. For parquet, it takes 43 ms for 10 records, meanwhile carbon takes 86 ms for 10 records ) > Optimizing collectData in ScannedResultCollector > > > Key: CARBONDATA-437 > URL: https://issues.apache.org/jira/browse/CARBONDATA-437 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong >Assignee: Raghunandan S > > row assembly speed is slow compared to other columnar file format after file > scan. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata pull request #412: [CARBONDATA-519]Added vector reader ...
Github user ravipesala commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/412#discussion_r92741003 --- Diff: integration/spark-common/src/main/scala/org/apache/carbondata/spark/rdd/CarbonScanRDD.scala --- @@ -150,12 +153,25 @@ class CarbonScanRDD[V: ClassTag]( val attemptContext = new TaskAttemptContextImpl(new Configuration(), attemptId) val format = prepareInputFormatForExecutor(attemptContext.getConfiguration) val inputSplit = split.asInstanceOf[CarbonSparkPartition].split.value -val reader = format.createRecordReader(inputSplit, attemptContext) +val model = format.getQueryModel(inputSplit, attemptContext) +val reader = { + if (vectorReader) { +val carbonRecordReader = createVectorizedCarbonRecordReader(model) +if (carbonRecordReader == null) { + new CarbonRecordReader(model, format.getReadSupportClass(attemptContext.getConfiguration)) +} else { + carbonRecordReader +} + } else { +new CarbonRecordReader(model, format.getReadSupportClass(attemptContext.getConfiguration)) --- End diff -- This vector carbon reader is specific to spark and it has spark dependencies that is why it is created in spark module. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Updated] (CARBONDATA-436) Make blocklet size configuration respect to the actual size (in terms of byte) of the blocklet
[ https://issues.apache.org/jira/browse/CARBONDATA-436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-436: - Description: Currently, the blocklet size is based on the row counts within the blocklet. The default value(12) is small for hdfs io. If we increase the value, which may cause too many Young-GC when we scan many columns, instead, we can extend the configuration with respect to the actual size of the blocklet. (was: Currently, the blocklet size is the row counts in the blocklet. The default value(12) is small for hdfs io. If we increase the value, which may cause too many Young-GC when we scan many columns. Like parquet, its row group size can be configed, and using hdfs block size as its default value.) Summary: Make blocklet size configuration respect to the actual size (in terms of byte) of the blocklet (was: change blocklet size related to the raw size of data ) > Make blocklet size configuration respect to the actual size (in terms of > byte) of the blocklet > -- > > Key: CARBONDATA-436 > URL: https://issues.apache.org/jira/browse/CARBONDATA-436 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong >Assignee: QiangCai > > Currently, the blocklet size is based on the row counts within the blocklet. > The default value(12) is small for hdfs io. If we increase the value, > which may cause too many Young-GC when we scan many columns, instead, we can > extend the configuration with respect to the actual size of the blocklet. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-433) Respect to blocklet size setting when scanning Carbondata files
[ https://issues.apache.org/jira/browse/CARBONDATA-433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-433: - Description: Currently, the blocklet size is configed through carbon.blocklet.size in carbon.properties file, its default value is 12 (number of rows) across all tables. this can potentially cause compatibility issue when changing the setting. we should consider to incorporate this information at file level, ideally stored in file footer, Carbon reader need to respect to the setting while reading. was: Currently, the blocklet size is configed with carbon.blocklet.size in carbon.properties file, its default value is 12. This will cause we can not read the previous table if we change the blocklet size Summary: Respect to blocklet size setting when scanning Carbondata files (was: blocklet size should belong to the table's meta data) > Respect to blocklet size setting when scanning Carbondata files > --- > > Key: CARBONDATA-433 > URL: https://issues.apache.org/jira/browse/CARBONDATA-433 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong >Assignee: cen yuhai > > Currently, the blocklet size is configed through carbon.blocklet.size in > carbon.properties file, its default value is 12 (number of rows) across > all tables. this can potentially cause compatibility issue when changing the > setting. > we should consider to incorporate this information at file level, ideally > stored in file footer, Carbon reader need to respect to the setting while > reading. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user jackylk commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Thanks for adding test case to spark2 integration, but it still needs improvement, I have created a JIRA for it. (CARBONDATA-538) --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Created] (CARBONDATA-538) Add test case to spark2 integration
Jacky Li created CARBONDATA-538: --- Summary: Add test case to spark2 integration Key: CARBONDATA-538 URL: https://issues.apache.org/jira/browse/CARBONDATA-538 Project: CarbonData Issue Type: Improvement Reporter: Jacky Li Fix For: 1.0.0-incubating Currently spark2 integration has very few test case, it should be improved -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user jackylk commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 LGTM --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #439: [CARBONDATA-536]initialize updateTableMetad...
Github user jackylk commented on the issue: https://github.com/apache/incubator-carbondata/pull/439 LGTM --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Resolved] (CARBONDATA-536) Initialize GlobalDictionaryUtil.updateTableMetadataFunc for Spark 2.x
[ https://issues.apache.org/jira/browse/CARBONDATA-536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacky Li resolved CARBONDATA-536. - > Initialize GlobalDictionaryUtil.updateTableMetadataFunc for Spark 2.x > - > > Key: CARBONDATA-536 > URL: https://issues.apache.org/jira/browse/CARBONDATA-536 > Project: CarbonData > Issue Type: Bug > Components: data-load >Affects Versions: 1.0.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 40m > Remaining Estimate: 0h > > GlobalDictionaryUtil.updateTableMetadataFunc needs to be initialized. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata pull request #439: [CARBONDATA-536]initialize updateTab...
Github user asfgit closed the pull request at: https://github.com/apache/incubator-carbondata/pull/439 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Updated] (CARBONDATA-432) Feed Carbon task‘s input size to Spark
[ https://issues.apache.org/jira/browse/CARBONDATA-432?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-432: - Description: Currently, the input size of task/stage couldn't be displayed properly in the spark web UI (was: Currently, the input size of task/stage does not display in the spark job UI) Summary: Feed Carbon task‘s input size to Spark (was: Adaptation task‘s input size to spark job UI) > Feed Carbon task‘s input size to Spark > -- > > Key: CARBONDATA-432 > URL: https://issues.apache.org/jira/browse/CARBONDATA-432 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong > Time Spent: 20m > Remaining Estimate: 0h > > Currently, the input size of task/stage couldn't be displayed properly in the > spark web UI -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-429) Eliminate unnecessary file name check in dictionary cache
[ https://issues.apache.org/jira/browse/CARBONDATA-429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-429: - Description: 1.there are currently many file name check for each column's dictionary cache, which cause unnecessary calls to HDFS getFileStatus. 2. in checkAndLoadDictionaryData, we get meta file's mtime from hdfs each time we invoke cache.get to check if the local cache is valid or not. The local dictionary cache may be invalid after parallel data load. This will in turn increase number of calls to getFileStatus as well. was: 1. In dictionary cache, there are currently many unnecessary file name check for each column, which increase the number of calling HDFS getFileStatus. 2. And in checkAndLoadDictionaryData, we get meta file's mtime from hdfs each time we call cache.get to check if the local is valid or not. The local dictionary cache may be invalid after another job finished load data. This will still increases calling getFileStatus Summary: Eliminate unnecessary file name check in dictionary cache (was: Remove unnecessary file name check in dictionary cache) > Eliminate unnecessary file name check in dictionary cache > - > > Key: CARBONDATA-429 > URL: https://issues.apache.org/jira/browse/CARBONDATA-429 > Project: CarbonData > Issue Type: Sub-task > Components: core >Affects Versions: 0.1.1-incubating >Reporter: Jacky Li >Assignee: Ashok Kumar > Fix For: 1.0.0-incubating > > Time Spent: 5h > Remaining Estimate: 0h > > 1.there are currently many file name check for each column's dictionary > cache, which cause unnecessary calls to HDFS getFileStatus. > 2. in checkAndLoadDictionaryData, we get meta file's mtime from hdfs each > time we invoke cache.get to check if the local cache is valid or not. The > local dictionary cache may be invalid after parallel data load. This will in > turn increase number of calls to getFileStatus as well. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-431) Improve compression ratio for numeric datatype
[ https://issues.apache.org/jira/browse/CARBONDATA-431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-431: - Description: Carbon has better compression ratio for String type, but worst for numeric data type, identify issues with current numeric datatype compression for carbon to get better compression ratio. DataTypeTextParquet Orc Carbon decimal 16G |11G | 6G|13G int 5G | 1G |1G |3G String24G |22G |11G |3G (no dictionary) ---high cardinality String 30G|4G |4G |1G -- Dictionary encode1G -- Dictionary encode without inverted index3G -- No dictionary encode ---low cardinality was: For the data type, carbon's string type has better compression ratio, but for numeric type, orc has the best compression. we should analysis numeric datatype for carbon to get better compression ratio DataTypeTextParquet Orc Carbon decimal 16G |11G | 6G|13G int 5G | 1G |1G |3G String24G |22G |11G |3G (no dictionary) ---high cardinality String 30G|4G |4G |1G -- Dictionary encode1G -- Dictionary encode without inverted index3G -- No dictionary encode ---low cardinality Summary: Improve compression ratio for numeric datatype (was: Analysis compression for numeric datatype compared with Parquet/ORC) > Improve compression ratio for numeric datatype > --- > > Key: CARBONDATA-431 > URL: https://issues.apache.org/jira/browse/CARBONDATA-431 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong >Assignee: Ashok Kumar > Fix For: 1.0.0-incubating > > Time Spent: 2h 50m > Remaining Estimate: 0h > > Carbon has better compression ratio for String type, but worst for numeric > data type, identify issues with current numeric datatype compression for > carbon to get better compression ratio. > DataType TextParquet Orc Carbon > decimal 16G |11G | 6G|13G > int 5G | 1G |1G |3G > String 24G |22G |11G |3G (no > dictionary) ---high cardinality > String30G|4G |4G |1G -- > Dictionary encode1G -- Dictionary encode without inverted index > 3G -- No dictionary encode ---low cardinality -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #440: [CARBONDATA-537][SPARK2] Fix bug for DICTIO...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/440 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/206/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Updated] (CARBONDATA-430) Optimizations for TPC-H benchmark
[ https://issues.apache.org/jira/browse/CARBONDATA-430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-430: - Summary: Optimizations for TPC-H benchmark (was: Carbon data tpch benchmark) > Optimizations for TPC-H benchmark > - > > Key: CARBONDATA-430 > URL: https://issues.apache.org/jira/browse/CARBONDATA-430 > Project: CarbonData > Issue Type: Improvement >Reporter: suo tong >Assignee: suo tong > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #440: [CARBONDATA-537][SPARK2] Fix bug for DICTIO...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/440 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/205/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #440: [CARBONDATA-537][SPARK2] Fix bug for...
GitHub user jackylk opened a pull request: https://github.com/apache/incubator-carbondata/pull/440 [CARBONDATA-537][SPARK2] Fix bug for DICTIONARY_EXCLUDE option in spark2 1. Fix bug for dictionary_exclude option in spark2 integration. In spark2, datat type name is changed from "string" to "stringtype", but `isStringAndTimestampColDictionaryExclude` is not modified. 2. Fix bug for data loading with no-kettle. In no-kettle loading, should not ask user to set kettle home environment variable. 3. clean up scala code style in `GlobalDictionaryUtil` You can merge this pull request into a Git repository by running: $ git pull https://github.com/jackylk/incubator-carbondata exclude Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-carbondata/pull/440.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #440 commit 0a8c098eeaa4cdb9a5b7bc361e0abb1e4bff Author: jackylk Date: 2016-12-15T16:37:55Z fix dictionary exclude commit 8434b2bdb91e6e0f6f93702bd6044696d559e812 Author: jackylk Date: 2016-12-16T00:46:34Z add testcase --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Created] (CARBONDATA-537) Bug fix for DICTIONARY_EXCLUDE option in spark2 integration
Jacky Li created CARBONDATA-537: --- Summary: Bug fix for DICTIONARY_EXCLUDE option in spark2 integration Key: CARBONDATA-537 URL: https://issues.apache.org/jira/browse/CARBONDATA-537 Project: CarbonData Issue Type: Bug Reporter: Jacky Li Fix For: 1.0.0-incubating 1. Fix bug for dictionary_exclude option in spark2 integration. In spark2, datat type name is changed from "string" to "stringtype", but `isStringAndTimestampColDictionaryExclude` is not modified. 2. Fix bug for data loading with no-kettle. In no-kettle loading, should not ask user to set kettle home environment variable. 3. clean up scala code style in `GlobalDictionaryUtil` -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-442) Query result mismatching with Hive
[ https://issues.apache.org/jira/browse/CARBONDATA-442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-442: - Summary: Query result mismatching with Hive (was: SELECT querry result mismatched with hive result) > Query result mismatching with Hive > -- > > Key: CARBONDATA-442 > URL: https://issues.apache.org/jira/browse/CARBONDATA-442 > Project: CarbonData > Issue Type: Bug >Reporter: SWATI RAO > > => I created table using following command : > create table Carbon_automation_test5 (imei string,deviceInformationId int,MAC > string,deviceColor string,device_backColor string,modelId string,marketName > string,AMSize string,ROMSize string,CUPAudit string,CPIClocked string,series > string,productionDate string,bomCode string,internalModels string, > deliveryTime string, channelsId string,channelsName string , deliveryAreaId > string, deliveryCountry string, deliveryProvince string, deliveryCity > string,deliveryDistrict string, deliveryStreet string,oxSingleNumber string, > ActiveCheckTime string, ActiveAreaId string, ActiveCountry string, > ActiveProvince string, Activecity string, ActiveDistrict string, ActiveStreet > string, ActiveOperatorId string, Active_releaseId string, Active_EMUIVersion > string,Active_operaSysVersion string, Active_BacVerNumber string, > Active_BacFlashVer string,Active_webUIVersion string, Active_webUITypeCarrVer > string,Active_webTypeDataVerNumber string, Active_operatorsVersion string, > Active_phonePADPartitionedVersions string,Latest_YEAR int, Latest_MONTH int, > Latest_DAY int, Latest_HOUR string, Latest_areaId string, Latest_country > string, Latest_province string, Latest_city string,Latest_district string, > Latest_street string, Latest_releaseId string,Latest_EMUIVersion string, > Latest_operaSysVersion string, Latest_BacVerNumber string,Latest_BacFlashVer > string, Latest_webUIVersion string, Latest_webUITypeCarrVer > string,Latest_webTypeDataVerNumber string, Latest_operatorsVersion > string,Latest_phonePADPartitionedVersions string, Latest_operatorId > string,gamePointDescription string, gamePointId int,contractNumber int) > stored by 'org.apache.carbondata.format' > => Load csv to table : > LOAD DATA INPATH 'hdfs://localhost:54310/user/hduser/100_olap.csv' INTO table > Carbon_automation_test5 OPTIONS('DELIMITER'= ',' ,'QUOTECHAR'= '"', > 'FILEHEADER'= > 'imei,deviceInformationId,MAC,deviceColor,device_backColor,modelId,marketName,AMSize,ROMSize,CUPAudit,CPIClocked,series,productionDate,bomCode,internalModels,deliveryTime,channelsId,channelsName,deliveryAreaId,deliveryCountry,deliveryProvince,deliveryCity,deliveryDistrict,deliveryStreet,oxSingleNumber,contractNumber,ActiveCheckTime,ActiveAreaId,ActiveCountry,ActiveProvince,Activecity,ActiveDistrict,ActiveStreet,ActiveOperatorId,Active_releaseId,Active_EMUIVersion,Active_operaSysVersion,Active_BacVerNumber,Active_BacFlashVer,Active_webUIVersion,Active_webUITypeCarrVer,Active_webTypeDataVerNumber,Active_operatorsVersion,Active_phonePADPartitionedVersions,Latest_YEAR,Latest_MONTH,Latest_DAY,Latest_HOUR,Latest_areaId,Latest_country,Latest_province,Latest_city,Latest_district,Latest_street,Latest_releaseId,Latest_EMUIVersion,Latest_operaSysVersion,Latest_BacVerNumber,Latest_BacFlashVer,Latest_webUIVersion,Latest_webUITypeCarrVer,Latest_webTypeDataVerNumber,Latest_operatorsVersion,Latest_phonePADPartitionedVersions,Latest_operatorId,gamePointId,gamePointDescription') > =>now executed SELECT querry : > SELECT Carbon_automation_test5.AMSize AS AMSize, > Carbon_automation_test5.ActiveCountry AS ActiveCountry, > Carbon_automation_test5.Activecity AS Activecity , > SUM(Carbon_automation_test5.gamePointId) AS Sum_gamePointId FROM ( SELECT > AMSize,ActiveCountry,gamePointId, Activecity FROM (select * from > Carbon_automation_test5) SUB_QRY ) Carbon_automation_test5 INNER JOIN ( > SELECT ActiveCountry, Activecity, AMSize FROM (select * from > Carbon_automation_test5) SUB_QRY ) Carbon_automation_vmall_test1 ON > Carbon_automation_test5.AMSize = Carbon_automation_vmall_test1.AMSize WHERE > NOT(Carbon_automation_test5.AMSize <= '3RAM size') GROUP BY > Carbon_automation_test5.AMSize, Carbon_automation_test5.ActiveCountry, > Carbon_automation_test5.Activecity ORDER BY Carbon_automation_test5.AMSize > ASC, Carbon_automation_test5.ActiveCountry ASC, > Carbon_automation_test5.Activecity ASC; > +++-+--+--+ > | AMSize | ActiveCountry | Activecity | Sum_gamePointId | > +++-+--+--+ > | 4RAM size | Chinese| changsha| 200860 | > | 4RAM size | Chinese| guangzhou | 38016| > | 4RAM size | Chinese| shenzhen| 49610| > | 4RAM size | Chi
[jira] [Updated] (CARBONDATA-443) Enable non-sort data loading
[ https://issues.apache.org/jira/browse/CARBONDATA-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-443: - Description: Improving data ingestion rate for fast ingestion for special use cases with potential side-effect of compromising query performance was: Improve dataloading performance Summary: Enable non-sort data loading (was: Implement nosort dataloading) > Enable non-sort data loading > > > Key: CARBONDATA-443 > URL: https://issues.apache.org/jira/browse/CARBONDATA-443 > Project: CarbonData > Issue Type: Improvement > Components: data-load >Affects Versions: 1.0.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 10m > Remaining Estimate: 0h > > Improving data ingestion rate for fast ingestion for special use cases with > potential side-effect of compromising query performance -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-464) Big GC occurs frequently when Carbon's blocklet size is enlarged from the default
[ https://issues.apache.org/jira/browse/CARBONDATA-464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-464: - Description: parquet might fetch from i/o 1 million(a row group) at one time, its data is divided into column chunks in columnar format, and each column trunk consists of many pages, the page(default size 1 MB) can be independently uncompressed and processed. In case of current carbon since we use larger blocklet, it requires larger processing memory as well, as it decompresses all projected column chunks within a blocklet, which consumes big amount of memory. Maybe we should consider to come up with similar approach to balance I/O and processing, but such a change requires carbon format level changes. was: parquet might fetch from i/o 1 million(a row group) at one time, its data is divided into column chunks in columnar format, and each column trunk consists of many pages, the page(default size 1 MB) can be independently uncompressed and processed. In case of current carbon if we use larger blocklet, it requires larger processing memory also, as it decompresses complete blocklet required columns and keeps it in memory. Maybe we should consider to come up with similar approach to balance I/O and processing, but such a change requires carbon format level changes. Summary: Big GC occurs frequently when Carbon's blocklet size is enlarged from the default (was: Too many tiems GC occurs in query if we increase the blocklet size) > Big GC occurs frequently when Carbon's blocklet size is enlarged from the > default > - > > Key: CARBONDATA-464 > URL: https://issues.apache.org/jira/browse/CARBONDATA-464 > Project: CarbonData > Issue Type: Sub-task >Reporter: suo tong > > parquet might fetch from i/o 1 million(a row group) at one time, its data is > divided into column chunks in columnar format, and each column trunk consists > of many pages, the page(default size 1 MB) can be independently uncompressed > and processed. > In case of current carbon since we use larger blocklet, it requires larger > processing memory as well, as it decompresses all projected column chunks > within a blocklet, which consumes big amount of memory. Maybe we should > consider to come up with similar approach to balance I/O and processing, but > such a change requires carbon format level changes. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-467) CREATE TABLE extension to support bucket table.
[ https://issues.apache.org/jira/browse/CARBONDATA-467?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-467: - Description: 1. CREATE TABLE Statement extension. {code} CREATE TABLE test(user_id BIGINT, firstname STRING, lastname STRING) CLUSTERED BY(user_id) INTO 32 BUCKETS STORED BY 'carbondata'; {code} 2. Carbon file format update (Thrift definition extension) 3. Respect to bucket definition during data load. Store the bucketid to carbondata index file was: Carbondata CREATE table command should support adding bucketing information. It should be like below. {code} CREATE TABLE test(user_id BIGINT, firstname STRING, lastname STRING) CLUSTERED BY(user_id) INTO 32 BUCKETS STORED BY 'carbondata'; {code} And also load the data using bucketing information. Store the bucketid to carbondata index file Summary: CREATE TABLE extension to support bucket table. (was: Add bucketing information while creating table and update in thrift format.And load the data using bucketing information.) > CREATE TABLE extension to support bucket table. > --- > > Key: CARBONDATA-467 > URL: https://issues.apache.org/jira/browse/CARBONDATA-467 > Project: CarbonData > Issue Type: Sub-task >Reporter: Ravindra Pesala > Time Spent: 1h 50m > Remaining Estimate: 0h > > 1. CREATE TABLE Statement extension. > {code} > CREATE TABLE test(user_id BIGINT, firstname STRING, lastname STRING) > CLUSTERED BY(user_id) INTO 32 BUCKETS STORED BY 'carbondata'; > {code} > 2. Carbon file format update (Thrift definition extension) > 3. Respect to bucket definition during data load. Store the bucketid to > carbondata index file -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-469) Leveraging Carbondata's bucketing info for optimized Join operation
[ https://issues.apache.org/jira/browse/CARBONDATA-469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-469: - Description: Optimize join in spark using bucketing information to avoid shuffling when possible. (was: Optimize join in spark using bucketing information and avoid shuffling) Summary: Leveraging Carbondata's bucketing info for optimized Join operation (was: Optimize join in spark using bucketing information ) > Leveraging Carbondata's bucketing info for optimized Join operation > --- > > Key: CARBONDATA-469 > URL: https://issues.apache.org/jira/browse/CARBONDATA-469 > Project: CarbonData > Issue Type: Sub-task >Reporter: Ravindra Pesala > > Optimize join in spark using bucketing information to avoid shuffling when > possible. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-478) Separate SparkRowReadSupportImpl implementation for integrating with Spark1.x vs. Spark 2.x
[ https://issues.apache.org/jira/browse/CARBONDATA-478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-478: - Issue Type: New Feature (was: Bug) Summary: Separate SparkRowReadSupportImpl implementation for integrating with Spark1.x vs. Spark 2.x (was: Spark2 module should have different SparkRowReadSupportImpl with spark1) > Separate SparkRowReadSupportImpl implementation for integrating with Spark1.x > vs. Spark 2.x > --- > > Key: CARBONDATA-478 > URL: https://issues.apache.org/jira/browse/CARBONDATA-478 > Project: CarbonData > Issue Type: New Feature > Components: data-query >Affects Versions: 0.2.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 0.5h > Remaining Estimate: 0h > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-484) Implement LRU cache for B-Tree
[ https://issues.apache.org/jira/browse/CARBONDATA-484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-484: - Description: LRU Cache for B-Tree is proposed to ensure to avoid out memory, when too many number of tables exits and all are not frequently used. Problem: CarbonData is maintaining two level of B-Tree cache, one at the driver level and another at executor level. Currently CarbonData has the mechanism to invalidate the segments and blocks cache for the invalid table segments, but there is no eviction policy for the unused cached object. So the instance at which complete memory is utilized then the system will not be able to process any new requests. Solution: In the cache maintained at the driver level and at the executor there must be objects in cache currently not in use. Therefore system should have the mechanism to below mechanism. 1. Set the max memory limit till which objects could be hold in the memory. 2. When configured memory limit reached then identify the cached objects currently not in use so that the required memory could be freed without impacting the existing process. 3. Eviction should be done only till the required memory is not meet. For details please refer to attachments. was: *LRU Cache for B-Tree* Problem: CarbonData is maintaining two level of B-Tree cache, one at the driver level and another at executor level. Currently CarbonData has the mechanism to invalidate the segments and blocks cache for the invalid table segments, but there is no eviction policy for the unused cached object. So the instance at which complete memory is utilized then the system will not be able to process any new requests. Solution: In the cache maintained at the driver level and at the executor there must be objects in cache currently not in use. Therefore system should have the mechanism to below mechanism. 1. Set the max memory limit till which objects could be hold in the memory. 2. When configured memory limit reached then identify the cached objects currently not in use so that the required memory could be freed without impacting the existing process. 3. Eviction should be done only till the required memory is not meet. For details please refer to attachments. Summary: Implement LRU cache for B-Tree (was: Implement LRU cache for B-Tree to ensure to avoid out memory, when too many number of tables exits and all are not frequently used.) > Implement LRU cache for B-Tree > --- > > Key: CARBONDATA-484 > URL: https://issues.apache.org/jira/browse/CARBONDATA-484 > Project: CarbonData > Issue Type: New Feature >Reporter: Mohammad Shahid Khan >Assignee: Mohammad Shahid Khan > Attachments: B-Tree LRU Cache.pdf > > > LRU Cache for B-Tree is proposed to ensure to avoid out memory, when too > many number of tables exits and all are not frequently used. > Problem: > CarbonData is maintaining two level of B-Tree cache, one at the driver level > and another at executor level. Currently CarbonData has the mechanism to > invalidate the segments and blocks cache for the invalid table segments, but > there is no eviction policy for the unused cached object. So the instance at > which complete memory is utilized then the system will not be able to process > any new requests. > Solution: > In the cache maintained at the driver level and at the executor there must be > objects in cache currently not in use. Therefore system should have the > mechanism to below mechanism. > 1. Set the max memory limit till which objects could be hold in the > memory. > 2. When configured memory limit reached then identify the cached > objects currently not in use so that the required memory could be freed > without impacting the existing process. > 3. Eviction should be done only till the required memory is not meet. > For details please refer to attachments. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-493) Insert into select from a empty table cause exception
[ https://issues.apache.org/jira/browse/CARBONDATA-493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-493: - Summary: Insert into select from a empty table cause exception (was: Insertinto sql can not select from a empty table) > Insert into select from a empty table cause exception > - > > Key: CARBONDATA-493 > URL: https://issues.apache.org/jira/browse/CARBONDATA-493 > Project: CarbonData > Issue Type: Bug >Affects Versions: 1.0.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 40m > Remaining Estimate: 0h > > example: > Insert into target_table select * from source_table > if source table is empty, data loading step will throw exception -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-495) Unify compressor interface
[ https://issues.apache.org/jira/browse/CARBONDATA-495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-495: - Description: Use compressor factory to unify the interface and eliminate small objects (was: Use factory for compressor to unify the interface and reduce small objects) Issue Type: Improvement (was: Bug) > Unify compressor interface > -- > > Key: CARBONDATA-495 > URL: https://issues.apache.org/jira/browse/CARBONDATA-495 > Project: CarbonData > Issue Type: Improvement >Affects Versions: 0.2.0-incubating >Reporter: Jacky Li >Assignee: Jacky Li > Fix For: 1.0.0-incubating > > Time Spent: 40m > Remaining Estimate: 0h > > Use compressor factory to unify the interface and eliminate small objects -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-516) [SPARK2]update union issue in CarbonLateDecoderRule for Spark 2.x integration
[ https://issues.apache.org/jira/browse/CARBONDATA-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-516: - Description: In spark2, Union class is no longer sub-class of BinaryNode. (was: In spark2, Union class is no longer the sub-class of BinaryNode. We need fix union issue in CarbonLateDecoderRule for spark2.) Issue Type: New Feature (was: Bug) Summary: [SPARK2]update union issue in CarbonLateDecoderRule for Spark 2.x integration (was: [SPARK2]fix union issue in CarbonLateDecoderRule) > [SPARK2]update union issue in CarbonLateDecoderRule for Spark 2.x integration > - > > Key: CARBONDATA-516 > URL: https://issues.apache.org/jira/browse/CARBONDATA-516 > Project: CarbonData > Issue Type: New Feature >Reporter: QiangCai >Assignee: QiangCai > Time Spent: 2.5h > Remaining Estimate: 0h > > In spark2, Union class is no longer sub-class of BinaryNode. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-519) Enable vector reader in Carbon-Spark 2.0 integration and Carbon layer
[ https://issues.apache.org/jira/browse/CARBONDATA-519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-519: - Description: Spark 2.0 supports vectorized reader and uses whole codegen to improve performance, Carbon will enable vectorized reader integrating with Spark to take advantage of new features of Spark2.x (was: Spark 2.0 supports batch reader and uses whole codegen to improve performance, so carbon also can implement vector reader and leverage the features of Spark2.0) Issue Type: New Feature (was: Improvement) > Enable vector reader in Carbon-Spark 2.0 integration and Carbon layer > - > > Key: CARBONDATA-519 > URL: https://issues.apache.org/jira/browse/CARBONDATA-519 > Project: CarbonData > Issue Type: New Feature >Reporter: Ravindra Pesala >Assignee: Ravindra Pesala > Time Spent: 2h 50m > Remaining Estimate: 0h > > Spark 2.0 supports vectorized reader and uses whole codegen to improve > performance, Carbon will enable vectorized reader integrating with Spark to > take advantage of new features of Spark2.x -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-522) New data loading flowcauses testcase failures like big decimal etc
[ https://issues.apache.org/jira/browse/CARBONDATA-522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-522: - Description: Pls check http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/105/. new data flow cause test regressions. was: Pls check http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/105/. I suggest that we should test new data loading flow when adding new feature. Summary: New data loading flowcauses testcase failures like big decimal etc (was: New data loading flow can not pass some testcase like big decimal etc) > New data loading flowcauses testcase failures like big decimal etc > -- > > Key: CARBONDATA-522 > URL: https://issues.apache.org/jira/browse/CARBONDATA-522 > Project: CarbonData > Issue Type: Bug >Reporter: Lionx >Assignee: Ravindra Pesala > > Pls check http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/105/. > new data flow cause test regressions. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-527) Greater than/less-than/Like filters optimization for dictionary encoded columns
[ https://issues.apache.org/jira/browse/CARBONDATA-527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-527: - Issue Type: New Feature (was: Improvement) Summary: Greater than/less-than/Like filters optimization for dictionary encoded columns (was: Greater than/less-than/Like filters optimization for dictionary columns) > Greater than/less-than/Like filters optimization for dictionary encoded > columns > --- > > Key: CARBONDATA-527 > URL: https://issues.apache.org/jira/browse/CARBONDATA-527 > Project: CarbonData > Issue Type: New Feature >Reporter: Sujith > Time Spent: 40m > Remaining Estimate: 0h > > Current design > In greater than/less-than/Like filters, system first iterates each row > present in the dictionary cache for identifying valid filter actual members > by applying the filter expression , once evaluation done system will hold the > list of identified valid filter actual member values(String), now in next > step again system will look up the dictionary cache in order to identify the > dictionary surrogate values of the identified members. this look up is an > additional cost to our system even though the look up methodology is an > binary search in dictionary cache. > > Proposed design/solution: > Identify the dictionary surrogate values in filter expression evaluation step > itself when actual dictionary values will be scanned for identifying valid > filter members . > Keep a dictionary counter variable which will be increased when system > iterates through the dictionary cache in order to retrieve each actual > member stored in dictionary cache , after this system will evaluate each row > against the filter expression to identify whether its a valid filter member > or not, while doing this process itself counter value can be taken as valid > selected dictionary value since the actual member values and its dictionary > values will be kept in same order in dictionary cache as the iteration order. > thus it will eliminate the further dictionary look up step which is required > to retrieve the dictionary surrogate value against identified actual valid > filter member. this can also increase significantly the filter query > performance of such filter queries which require expression evaluation to > identify it the filter members by looking up dictionary cache, like greater > than/less-than/Like filters . > Note : this optimization is applicable for dictionary columns. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-531) Eliminate spark dependency in carbon core
[ https://issues.apache.org/jira/browse/CARBONDATA-531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-531: - Description: Clean up the interface and take out Spark dependency on Carbon-core module. (was: Carbon-core module should not depend on spark ) Summary: Eliminate spark dependency in carbon core (was: Remove spark dependency in carbon core) > Eliminate spark dependency in carbon core > - > > Key: CARBONDATA-531 > URL: https://issues.apache.org/jira/browse/CARBONDATA-531 > Project: CarbonData > Issue Type: Improvement >Affects Versions: 0.2.0-incubating >Reporter: Jacky Li > Fix For: 1.0.0-incubating > > Time Spent: 0.5h > Remaining Estimate: 0h > > Clean up the interface and take out Spark dependency on Carbon-core module. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-536) Initialize GlobalDictionaryUtil.updateTableMetadataFunc for Spark 2.x
[ https://issues.apache.org/jira/browse/CARBONDATA-536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-536: - Description: GlobalDictionaryUtil.updateTableMetadataFunc needs to be initialized. (was: For spark2, GlobalDictionaryUtil.updateTableMetadataFunc should been initialized) Summary: Initialize GlobalDictionaryUtil.updateTableMetadataFunc for Spark 2.x (was: For spark2, GlobalDictionaryUtil.updateTableMetadataFunc should been initialized) > Initialize GlobalDictionaryUtil.updateTableMetadataFunc for Spark 2.x > - > > Key: CARBONDATA-536 > URL: https://issues.apache.org/jira/browse/CARBONDATA-536 > Project: CarbonData > Issue Type: Bug > Components: data-load >Affects Versions: 1.0.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 0.5h > Remaining Estimate: 0h > > GlobalDictionaryUtil.updateTableMetadataFunc needs to be initialized. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-322) Integration with spark 2.x
[ https://issues.apache.org/jira/browse/CARBONDATA-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-322: - Issue Type: New Feature (was: Improvement) > Integration with spark 2.x > > > Key: CARBONDATA-322 > URL: https://issues.apache.org/jira/browse/CARBONDATA-322 > Project: CarbonData > Issue Type: New Feature > Components: spark-integration >Affects Versions: 0.2.0-incubating >Reporter: Fei Wang >Assignee: Fei Wang > Fix For: 1.0.0-incubating > > > Since spark 2.0 released. there are many nice features such as more efficient > parser, vectorized execution, adaptive execution. > It is good to integrate with spark 2.x > current integration up to Spark v1.6 is tightly coupled with spark, we would > like to cleanup the interface with following design points in mind: > 1. decoupled with Spark, integration based on Spark's v2 datasource API > 2. Enable vectorized carbon reader > 3. Support saving DataFrame to Carbondata file through Carbondata's output > format. > ... -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-322) Integration with spark 2.x
[ https://issues.apache.org/jira/browse/CARBONDATA-322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-322: - Description: Since spark 2.0 released. there are many nice features such as more efficient parser, vectorized execution, adaptive execution. It is good to integrate with spark 2.x current integration up to Spark v1.6 is tightly coupled with spark, we would like to cleanup the interface with following design points in mind: 1. decoupled with Spark, integration based on Spark's v2 datasource API 2. Enable vectorized carbon reader 3. Support saving DataFrame to Carbondata file through Carbondata's output format. ... was: As spark 2.0 released. there are many nice features such as more efficient parser, vectorized execution, adaptive execution. It is good to integrate with spark 2.x Another side now in carbondata, spark integration is heavy coupling with spark code and the code need clean, we should redesign the spark integration, it should satisfy flowing requirement: 1. decoupled with spark, integrate according to spark datasource API(V2) 2. This integration should support vectorized carbon reader 3. Supoort write to carbondata from dadatrame ... Issue Type: Improvement (was: Bug) Summary: Integration with spark 2.x (was: integrate spark 2.x ) > Integration with spark 2.x > > > Key: CARBONDATA-322 > URL: https://issues.apache.org/jira/browse/CARBONDATA-322 > Project: CarbonData > Issue Type: Improvement > Components: spark-integration >Affects Versions: 0.2.0-incubating >Reporter: Fei Wang >Assignee: Fei Wang > Fix For: 1.0.0-incubating > > > Since spark 2.0 released. there are many nice features such as more efficient > parser, vectorized execution, adaptive execution. > It is good to integrate with spark 2.x > current integration up to Spark v1.6 is tightly coupled with spark, we would > like to cleanup the interface with following design points in mind: > 1. decoupled with Spark, integration based on Spark's v2 datasource API > 2. Enable vectorized carbon reader > 3. Support saving DataFrame to Carbondata file through Carbondata's output > format. > ... -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-535) Enable Date and Char datatype support for Carbondata
[ https://issues.apache.org/jira/browse/CARBONDATA-535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jihong MA updated CARBONDATA-535: - Description: Add Date and Char datatype support for Carbondata (was: carbondata should support datatype: Date and Char) Summary: Enable Date and Char datatype support for Carbondata (was: carbondata should support datatype: Date and Char) > Enable Date and Char datatype support for Carbondata > > > Key: CARBONDATA-535 > URL: https://issues.apache.org/jira/browse/CARBONDATA-535 > Project: CarbonData > Issue Type: Improvement > Components: file-format >Affects Versions: 1.0.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > Time Spent: 10m > Remaining Estimate: 0h > > Add Date and Char datatype support for Carbondata -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #423: [CARBONDATA-527] Greater than/less-than/Lik...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/423 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/204/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #423: [CARBONDATA-527] Greater than/less-than/Lik...
Github user sujith71955 commented on the issue: https://github.com/apache/incubator-carbondata/pull/423 Please review and merge this PR. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #439: [CARBONDATA-536]initialize updateTableMetad...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/439 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/203/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #439: [CARBONDATA-536]initialize updateTableMetad...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/439 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/202/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata pull request #439: [CARBONDATA-536]initialize updateTab...
GitHub user QiangCai opened a pull request: https://github.com/apache/incubator-carbondata/pull/439 [CARBONDATA-536]initialize updateTableMetadata method in LoadTable for Spark2 For spark2, GlobalDictionaryUtil.updateTableMetadataFunc should been initialized You can merge this pull request into a Git repository by running: $ git pull https://github.com/QiangCai/incubator-carbondata fixBugInLoadTable Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-carbondata/pull/439.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #439 commit 1f28ef9864e2d45807bb7c6bb1cbb51f65f423e3 Author: QiangCai Date: 2016-12-15T16:26:09Z fixLoadTableForSpark2 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Created] (CARBONDATA-536) For spark2, GlobalDictionaryUtil.updateTableMetadataFunc should been initialized
QiangCai created CARBONDATA-536: --- Summary: For spark2, GlobalDictionaryUtil.updateTableMetadataFunc should been initialized Key: CARBONDATA-536 URL: https://issues.apache.org/jira/browse/CARBONDATA-536 Project: CarbonData Issue Type: Bug Components: data-load Affects Versions: 1.0.0-incubating Reporter: QiangCai Assignee: QiangCai Fix For: 1.0.0-incubating For spark2, GlobalDictionaryUtil.updateTableMetadataFunc should been initialized -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #433: [WIP] fix testcase failure for -Pno-kettle ...
Github user littleJava commented on the issue: https://github.com/apache/incubator-carbondata/pull/433 another question: is hive optional ? I just test carbondata in spark2 local driver model. and what is the role-playing of derby , how can i use derby ? Thank you ! by the way : the new version of carbondata-format-1.0.0-incubating-SNAPSHOT should be uploaded 😀 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #433: [WIP] fix testcase failure for -Pno-kettle ...
Github user littleJava commented on the issue: https://github.com/apache/incubator-carbondata/pull/433 hi, i ran 'org.apache.spark.sql.examples.CarbonExample' with spark2.0.2 submit , and got the exception: ``` AUDIT 15-12 16:04:24,691 - [spark-host][root][Thread-1]Table created with Database name [default] and Table name [carbon_table] WARN 15-12 16:04:24,691 - Couldn't find corresponding Hive SerDe for data source provider org.apache.spark.sql.CarbonSource. Persisting data source relation `carbon_table` into Hive metastore in Spark SQL specific format, which is NOT compatible with Hive. Exception in thread "main" java.lang.UnsupportedOperationException: loadTable is not implemented at org.apache.spark.sql.catalyst.catalog.InMemoryCatalog.loadTable(InMemoryCatalog.scala:290) at org.apache.spark.sql.catalyst.catalog.SessionCatalog.loadTable(SessionCatalog.scala:297) at org.apache.spark.sql.execution.command.LoadDataCommand.run(tables.scala:335) at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult$lzycompute(commands.scala:58) at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult(commands.scala:56) at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114) at org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86) at org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86) at org.apache.spark.sql.Dataset.(Dataset.scala:186) at org.apache.spark.sql.Dataset.(Dataset.scala:167) at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65) at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582) at org.apache.spark.sql.examples.CarbonExample$.main(Carbon.scala:105) at org.apache.spark.sql.examples.CarbonExample.main(Carbon.scala) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.spark.deploy.SparkSubmit$.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:736) at org.apache.spark.deploy.SparkSubmit$.doRunMain$1(SparkSubmit.scala:185) at org.apache.spark.deploy.SparkSubmit$.submit(SparkSubmit.scala:210) at org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit.scala:124) ``` --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/201/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/200/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/199/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/198/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/197/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Success with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/196/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user QiangCai commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 @jackylk Added test case Local test case pass for spark1.5 and spark2 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/195/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/194/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/193/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #413: [CARBONDATA-516][SPARK2]fix union issue in ...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/413 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/192/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Closed] (CARBONDATA-394) Carbon Loading data from files having invalid extensions or no extension
[ https://issues.apache.org/jira/browse/CARBONDATA-394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] SWATI RAO closed CARBONDATA-394. Resolution: Not A Problem > Carbon Loading data from files having invalid extensions or no extension > > > Key: CARBONDATA-394 > URL: https://issues.apache.org/jira/browse/CARBONDATA-394 > Project: CarbonData > Issue Type: Bug >Reporter: SWATI RAO >Assignee: xbkaishui >Priority: Trivial > > When I try to run the following queries : > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file1.csv.csv' > INTO table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath > 'hdfs://localhost:54310/user/hive/warehouse/file2.csv.csv.csv.csv' INTO table > empdata options('DELIMITER'=',', 'FILEHEADER'='id, name','QUOTECHAR'='"'); > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file3.txttt' > INTO table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file4' INTO > table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath > 'hdfs://localhost:54310/user/hive/warehouse/file5.txt.bat.csv' INTO table > empdata options('DELIMITER'=',', 'FILEHEADER'='id, name','QUOTECHAR'='"'); > We should get Input File Errors, but the data is loaded successfully into the > Carbon table. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CARBONDATA-394) Carbon Loading data from files having invalid extensions or no extension
[ https://issues.apache.org/jira/browse/CARBONDATA-394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750987#comment-15750987 ] SWATI RAO edited comment on CARBONDATA-394 at 12/15/16 10:13 AM: - We had a discussion with the team. This is not an issue. So we are closing this ticket. was (Author: swati.rao): So we are closing this issue. > Carbon Loading data from files having invalid extensions or no extension > > > Key: CARBONDATA-394 > URL: https://issues.apache.org/jira/browse/CARBONDATA-394 > Project: CarbonData > Issue Type: Bug >Reporter: SWATI RAO >Assignee: xbkaishui >Priority: Trivial > > When I try to run the following queries : > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file1.csv.csv' > INTO table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath > 'hdfs://localhost:54310/user/hive/warehouse/file2.csv.csv.csv.csv' INTO table > empdata options('DELIMITER'=',', 'FILEHEADER'='id, name','QUOTECHAR'='"'); > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file3.txttt' > INTO table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file4' INTO > table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath > 'hdfs://localhost:54310/user/hive/warehouse/file5.txt.bat.csv' INTO table > empdata options('DELIMITER'=',', 'FILEHEADER'='id, name','QUOTECHAR'='"'); > We should get Input File Errors, but the data is loaded successfully into the > Carbon table. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CARBONDATA-394) Carbon Loading data from files having invalid extensions or no extension
[ https://issues.apache.org/jira/browse/CARBONDATA-394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750987#comment-15750987 ] SWATI RAO commented on CARBONDATA-394: -- So we are closing this issue. > Carbon Loading data from files having invalid extensions or no extension > > > Key: CARBONDATA-394 > URL: https://issues.apache.org/jira/browse/CARBONDATA-394 > Project: CarbonData > Issue Type: Bug >Reporter: SWATI RAO >Assignee: xbkaishui >Priority: Trivial > > When I try to run the following queries : > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file1.csv.csv' > INTO table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath > 'hdfs://localhost:54310/user/hive/warehouse/file2.csv.csv.csv.csv' INTO table > empdata options('DELIMITER'=',', 'FILEHEADER'='id, name','QUOTECHAR'='"'); > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file3.txttt' > INTO table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath 'hdfs://localhost:54310/user/hive/warehouse/file4' INTO > table empdata options('DELIMITER'=',', 'FILEHEADER'='id, > name','QUOTECHAR'='"'); > LOAD DATA inpath > 'hdfs://localhost:54310/user/hive/warehouse/file5.txt.bat.csv' INTO table > empdata options('DELIMITER'=',', 'FILEHEADER'='id, name','QUOTECHAR'='"'); > We should get Input File Errors, but the data is loaded successfully into the > Carbon table. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CARBONDATA-327) Drop Daabase unexpected behaviour.
[ https://issues.apache.org/jira/browse/CARBONDATA-327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750940#comment-15750940 ] anubhav tarar commented on CARBONDATA-327: -- i create a database in hive and carbondata then dropped both databases when i execute show table in hive it gives an exception that database does not exists but in carbon data it does not give any exception in hive--- i got following output hive> CREATE DATABASE SAMPLE; OK hive (default)> use SAMPLE; OK hive (SAMPLE)> drop database SAMPLE; OK hive (SAMPLE)> use SAMPLE; FAILED: SemanticException [Error 10072]: Database does not exist: SAMPLE hive (SAMPLE)> show tables; FAILED: SemanticException [Error 10072]: Database does not exist: SAMPLE where as in carbondata i got folowing output 0: jdbc:hive2://localhost:1> CREATE DATABASE SAMPLE; 0: jdbc:hive2://localhost:1> USE SAMPLE; 0: jdbc:hive2://localhost:1> DROP DATABASE SAMPLE; 0: jdbc:hive2://localhost:1> USE SAMPLE; Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED: SemanticException [Error 10072]: Database does not exist: SAMPLE (state=,code=0) 0: jdbc:hive2: 0: jdbc:hive2://localhost:1>show tables; ++--+--+ | tableName | isTemporary | ++--+--+ ++--+--+ No rows selected (0.066 seconds) > Drop Daabase unexpected behaviour. > --- > > Key: CARBONDATA-327 > URL: https://issues.apache.org/jira/browse/CARBONDATA-327 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > > Hey team, I am creating a database as below: > 0: jdbc:hive2://127.0.0.1:1> create database Test; > +-+--+ > | result | > +-+--+ > +-+--+ > After creating an database i am using that database using below command: > 0: jdbc:hive2://127.0.0.1:1> use Test; > +-+--+ > | result | > +-+--+ > +-+--+ > After That, i am drop the database as below: > 0: jdbc:hive2://127.0.0.1:1> drop database test; > +-+--+ > | result | > +-+--+ > +-+--+ > The database drop successfully. I am expecting, after that the carbon data > automatically switch to the "default" database. But when i trying to execute > command "show tables" the result return nothing as below : > 0: jdbc:hive2://127.0.0.1:1> show tables; > ++--+--+ > | tableName | isTemporary | > ++--+--+ > ++--+--+ > No rows selected (0.019 seconds) > But my default database contains some table as below: > 0: jdbc:hive2://127.0.0.1:1> use default; > +-+--+ > | result | > +-+--+ > +-+--+ > No rows selected (0.024 seconds) > 0: jdbc:hive2://127.0.0.1:1> show tables; > ++--+--+ > | tableName | isTemporary | > ++--+--+ > | one| false| > | two| false| > ++--+--+ > 2 rows selected (0.013 seconds) > If I am following all above step on Hive, Hive gave us an error on show > tables after drop the database as below: > hive> drop database test; > OK > Time taken: 0.628 seconds > hive> show databases; > OK > default > Time taken: 0.022 seconds, Fetched: 1 row(s) > hive> show tables; > FAILED: SemanticException [Error 10072]: Database does not exist: test -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (CARBONDATA-535) carbondata should support datatype: Date and Char
[ https://issues.apache.org/jira/browse/CARBONDATA-535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacky Li resolved CARBONDATA-535. - Resolution: Fixed > carbondata should support datatype: Date and Char > - > > Key: CARBONDATA-535 > URL: https://issues.apache.org/jira/browse/CARBONDATA-535 > Project: CarbonData > Issue Type: Improvement > Components: file-format >Affects Versions: 1.0.0-incubating >Reporter: QiangCai >Assignee: QiangCai > Fix For: 1.0.0-incubating > > > carbondata should support datatype: Date and Char -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata pull request #411: [CARBONDATA-535]Support data type: d...
Github user asfgit closed the pull request at: https://github.com/apache/incubator-carbondata/pull/411 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-carbondata issue #310: [CARBONDATA-401] One Pass Load
Github user foryou2030 commented on the issue: https://github.com/apache/incubator-carbondata/pull/310 @jackylk, pls review it, thanks --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Comment Edited] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750738#comment-15750738 ] Himani Arora edited comment on CARBONDATA-324 at 12/15/16 8:20 AM: --- This seems no longer a bug to me. I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected: !https://issues.apache.org/jira/secure/attachment/12843371/CARBONDATA-324.png! was (Author: himani1): This seems no longer a bug to me. I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > Attachments: CARBONDATA-324.png > > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Himani Arora updated CARBONDATA-324: Attachment: CARBONDATA-324.png > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > Attachments: CARBONDATA-324.png > > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750738#comment-15750738 ] Himani Arora edited comment on CARBONDATA-324 at 12/15/16 8:18 AM: --- This seems no longer a bug to me. I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected was (Author: himani1): This seems no longer a bug to me. I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected !https://issues.apache.org/jira/secure/attachment/12843370/Screenshot%20from%202016-10-19%2010-54-06.png! > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Himani Arora updated CARBONDATA-324: Attachment: (was: Screenshot from 2016-10-19 10-54-06.png) > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750738#comment-15750738 ] Himani Arora edited comment on CARBONDATA-324 at 12/15/16 8:17 AM: --- This seems no longer a bug to me. I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected !https://issues.apache.org/jira/secure/attachment/12843370/Screenshot%20from%202016-10-19%2010-54-06.png! was (Author: himani1): I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected and so this seems no longer a bug to me. > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > Attachments: Screenshot from 2016-10-19 10-54-06.png > > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15750746#comment-15750746 ] Anurag Srivastava commented on CARBONDATA-324: -- !https://issues.apache.org/jira/secure/attachment/12843370/Screenshot%20from%202016-10-19%2010-54-06.png! > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > Attachments: Screenshot from 2016-10-19 10-54-06.png > > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Issue Comment Deleted] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Srivastava updated CARBONDATA-324: - Comment: was deleted (was: !https://issues.apache.org/jira/secure/attachment/12843370/Screenshot%20from%202016-10-19%2010-54-06.png!) > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > Attachments: Screenshot from 2016-10-19 10-54-06.png > > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (CARBONDATA-324) Decimal and Bigint type columns contains Null, after load data
[ https://issues.apache.org/jira/browse/CARBONDATA-324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Himani Arora updated CARBONDATA-324: Attachment: Screenshot from 2016-10-19 10-54-06.png I did the following steps: create table test(id INT,name STRING,salary DECIMAL,data BIGINT) stored by 'carbondata'; LOAD DATA INPATH "hdfs://localhost:54310/user/test1.csv" INTO TABLE test options('DELIMITER'=',', 'FILEHEADER'='id, name, salary, data'); test1.csv contains the following fields: himani,1,90,292092 The output was fine and as expected and so this seems no longer a bug to me. > Decimal and Bigint type columns contains Null, after load data > -- > > Key: CARBONDATA-324 > URL: https://issues.apache.org/jira/browse/CARBONDATA-324 > Project: CarbonData > Issue Type: Bug >Reporter: Harmeet Singh > Attachments: Screenshot from 2016-10-19 10-54-06.png > > > Using Thrift server and Beeling client, i am trying to create a table and > load the data from CSV. My tables contains BigInt and Decimal Column types, > After load the data using Load Data command, The BigInt and Decimal Column > contains Null Value. Bellow are the steps: > Step 1: > > create database wednesday; > > use wednesday; > > CREATE TABLE one (id int, age iNt, name String, salary decimal, data > > bigInt, weight double, dob timeStamp) STORED BY 'carbondata'; > Step 2: > Create a csv file which contains column values as below: > id, age, name, salary, data, weight, dob > 1, 54, james, 90, 292092, 34.2, 2016-05-04 22:55:00 > Step 3: > Load the data from CSV file as below: > > LOAD DATA INPATH 'hdfs://localhost:54310/home/harmeet/sample3.csv' INTO > > TABLE one; > Step 4: > Select the data from table one, and BigInt and Decimal column contains Null > value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #339: [CARBONDATA-429] Remove unnecessary file na...
Github user CarbonDataQA commented on the issue: https://github.com/apache/incubator-carbondata/pull/339 Build Failed with Spark 1.5.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/191/ --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Created] (CARBONDATA-535) carbondata should support datatype: Date and Char
QiangCai created CARBONDATA-535: --- Summary: carbondata should support datatype: Date and Char Key: CARBONDATA-535 URL: https://issues.apache.org/jira/browse/CARBONDATA-535 Project: CarbonData Issue Type: Improvement Components: file-format Affects Versions: 1.0.0-incubating Reporter: QiangCai Assignee: QiangCai Fix For: 1.0.0-incubating carbondata should support datatype: Date and Char -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-carbondata issue #339: [CARBONDATA-429] Remove unnecessary file na...
Github user chenliang613 commented on the issue: https://github.com/apache/incubator-carbondata/pull/339 test this please --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---