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
[hidden email] or file a JIRA ticket
with INFRA.
---
Locked
