You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by chenerlu <gi...@git.apache.org> on 2017/04/20 13:28:21 UTC
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
GitHub user chenerlu opened a pull request:
https://github.com/apache/incubator-carbondata/pull/823
[CARBONDATA-964] Undate FAQs docment
Problem:
How Carbon will behave when execute insert operation in abnormal scenarios?
Solution:
Update FAQs document for describe Carbon's behave when execute insert operation in abnormal scenarios.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/chenerlu/incubator-carbondata chenerlu-patch-1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-carbondata/pull/823.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 #823
----
commit 61717e9151d1abf4164c96d3e24f5121612554dd
Author: chenerlu <ch...@huawei.com>
Date: 2017-04-20T13:16:42Z
Update faq.md
----
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
Posted by chenliang613 <gi...@git.apache.org>.
Github user chenliang613 commented on a diff in the pull request:
https://github.com/apache/incubator-carbondata/pull/823#discussion_r112705743
--- Diff: docs/faq.md ---
@@ -74,4 +75,57 @@ The property carbon.lock.type configuration specifies the type of lock to be acq
## How to resolve Abstract Method Error?
In order to build CarbonData project it is necessary to specify the spark profile. The spark profile sets the Spark Version. You need to specify the ``spark version`` while using Maven to build project.
+## How Carbon will behave when execute insert operation in abnormal scenarios?
+Carbon support insert operetion, you can refer to the syntax mentioned in DML Operations on CarbonData.
+First, create a soucre table and load data into this created table. Create source table as follows:
+```
+CREATE TABLE source_table(
+id String,
+name String,
+city String)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY ",";
+```
+Data inside source table as follows:
--- End diff --
Can remove the two sentences : "Create source table as follows:", "Data inside source table as follows:"
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
Posted by chenliang613 <gi...@git.apache.org>.
Github user chenliang613 commented on a diff in the pull request:
https://github.com/apache/incubator-carbondata/pull/823#discussion_r112706476
--- Diff: docs/faq.md ---
@@ -74,4 +75,57 @@ The property carbon.lock.type configuration specifies the type of lock to be acq
## How to resolve Abstract Method Error?
In order to build CarbonData project it is necessary to specify the spark profile. The spark profile sets the Spark Version. You need to specify the ``spark version`` while using Maven to build project.
+## How Carbon will behave when execute insert operation in abnormal scenarios?
+Carbon support insert operetion, you can refer to the syntax mentioned in DML Operations on CarbonData.
+First, create a soucre table and load data into this created table. Create source table as follows:
+```
+CREATE TABLE source_table(
+id String,
+name String,
+city String)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY ",";
+```
+Data inside source table as follows:
+```
+SELECT * FROM source_table;
+1 jack beijing
+2 erlu hangzhou
+3 davi shenzhen
+```
+**Scenario 1** :
+
+Since the column order in carbon table is different from source table, you may get unexpected result when query carbon table. This phenomenon is same with insert data into hive table. Create carbon table as follows:
+```
+CREATE TABLE IF NOT EXISTS carbon_table(
+id String,
+city String,
+name String)
+STORED BY 'carbondata';
+```
+Then execute insert into operation:
+```
+INSERT INTO TABLE carbon_table SELECT * FROM source_table;
+```
+After insert operation, you will get the data in source table's order when query carbon table, rather than in carbon table's column order as expected.
+```
+SELECT * FROM carbon_table;
+1 jack beijing
--- End diff --
put table header , it is more easy to identify the difference
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
Posted by chenliang613 <gi...@git.apache.org>.
Github user chenliang613 commented on a diff in the pull request:
https://github.com/apache/incubator-carbondata/pull/823#discussion_r112704501
--- Diff: docs/faq.md ---
@@ -74,4 +75,57 @@ The property carbon.lock.type configuration specifies the type of lock to be acq
## How to resolve Abstract Method Error?
In order to build CarbonData project it is necessary to specify the spark profile. The spark profile sets the Spark Version. You need to specify the ``spark version`` while using Maven to build project.
+## How Carbon will behave when execute insert operation in abnormal scenarios?
+Carbon support insert operetion, you can refer to the syntax mentioned in DML Operations on CarbonData.
--- End diff --
DML Operations on CarbonData can give one link
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
Posted by chenliang613 <gi...@git.apache.org>.
Github user chenliang613 commented on a diff in the pull request:
https://github.com/apache/incubator-carbondata/pull/823#discussion_r112705528
--- Diff: docs/faq.md ---
@@ -74,4 +75,57 @@ The property carbon.lock.type configuration specifies the type of lock to be acq
## How to resolve Abstract Method Error?
In order to build CarbonData project it is necessary to specify the spark profile. The spark profile sets the Spark Version. You need to specify the ``spark version`` while using Maven to build project.
+## How Carbon will behave when execute insert operation in abnormal scenarios?
+Carbon support insert operetion, you can refer to the syntax mentioned in DML Operations on CarbonData.
+First, create a soucre table and load data into this created table. Create source table as follows:
--- End diff --
How about :
First, create a source table in hive and load data into this created table with the below script:
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata issue #823: [CARBONDATA-964] Undate FAQs docment
Posted by chenliang613 <gi...@git.apache.org>.
Github user chenliang613 commented on the issue:
https://github.com/apache/incubator-carbondata/pull/823
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata issue #823: [CARBONDATA-964] Undate FAQs docment
Posted by CarbonDataQA <gi...@git.apache.org>.
Github user CarbonDataQA commented on the issue:
https://github.com/apache/incubator-carbondata/pull/823
Build Success with Spark 1.6.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/1758/
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata issue #823: [CARBONDATA-964] Undate FAQs docment
Posted by CarbonDataQA <gi...@git.apache.org>.
Github user CarbonDataQA commented on the issue:
https://github.com/apache/incubator-carbondata/pull/823
Build Success with Spark 1.6.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/1710/
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
Posted by chenliang613 <gi...@git.apache.org>.
Github user chenliang613 commented on a diff in the pull request:
https://github.com/apache/incubator-carbondata/pull/823#discussion_r112704239
--- Diff: docs/faq.md ---
@@ -74,4 +75,57 @@ The property carbon.lock.type configuration specifies the type of lock to be acq
## How to resolve Abstract Method Error?
In order to build CarbonData project it is necessary to specify the spark profile. The spark profile sets the Spark Version. You need to specify the ``spark version`` while using Maven to build project.
+## How Carbon will behave when execute insert operation in abnormal scenarios?
+Carbon support insert operetion, you can refer to the syntax mentioned in DML Operations on CarbonData.
--- End diff --
wrong word, should be operation
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata issue #823: [CARBONDATA-964] Undate FAQs docment
Posted by CarbonDataQA <gi...@git.apache.org>.
Github user CarbonDataQA commented on the issue:
https://github.com/apache/incubator-carbondata/pull/823
Build Success with Spark 1.6.2, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder/1760/
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---
[GitHub] incubator-carbondata pull request #823: [CARBONDATA-964] Undate FAQs docment
Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-carbondata/pull/823
---
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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---