You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2016/10/21 10:07:49 UTC
[1/8] kylin git commit: KYLIN-2070 add more info in the REST API
[Forced Update!]
Repository: kylin
Updated Branches:
refs/heads/KYLIN-1971 787a69246 -> f1f69d44e (forced update)
KYLIN-2070 add more info in the REST API
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/4f76e16c
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/4f76e16c
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/4f76e16c
Branch: refs/heads/KYLIN-1971
Commit: 4f76e16c491b0d50a61bd68c9d0fd54ee4f87e4a
Parents: 0eab5e0
Author: shaofengshi <sh...@apache.org>
Authored: Fri Oct 21 10:37:24 2016 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Fri Oct 21 10:37:24 2016 +0800
----------------------------------------------------------------------
.../kylin/rest/controller/CubeController.java | 8 ++++-
.../kylin/rest/response/HBaseResponse.java | 36 ++++++++++++++++++++
2 files changed, 43 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/4f76e16c/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
----------------------------------------------------------------------
diff --git a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
index eefc452..a3f9ec0 100644
--- a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
+++ b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
@@ -277,7 +277,7 @@ public class CubeController extends BasicController {
@RequestMapping(value = "/{cubeName}/rebuild2", method = { RequestMethod.PUT })
@ResponseBody
public JobInstance rebuild(@PathVariable String cubeName, @RequestBody JobBuildRequest2 req) {
- return buildInternal(cubeName, 0, 0, req.getSourceOffsetStart(), req.getSourceOffsetEnd(), req.getSourcePartitionOffsetStart(), req.getSourcePartitionOffsetEnd(), req.getBuildType(), req.isForce());
+ return buildInternal(cubeName, 0, 0, req.getSourceOffsetStart(), req.getSourceOffsetEnd(), req.getSourcePartitionOffsetStart(), req.getSourcePartitionOffsetEnd(), req.getBuildType(), req.isForce());
}
private JobInstance buildInternal(String cubeName, long startTime, long endTime, //
@@ -527,6 +527,12 @@ public class CubeController extends BasicController {
hr.setTableName(tableName);
hr.setDateRangeStart(segment.getDateRangeStart());
hr.setDateRangeEnd(segment.getDateRangeEnd());
+ hr.setSegmentName(segment.getName());
+ hr.setSourceCount(segment.getInputRecords());
+ if (segment.isSourceOffsetsOn()) {
+ hr.setSourceOffsetStart(segment.getSourceOffsetStart());
+ hr.setSourceOffsetEnd(segment.getSourceOffsetEnd());
+ }
hbase.add(hr);
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/4f76e16c/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
----------------------------------------------------------------------
diff --git a/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java b/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
index 607d61a..985596d 100644
--- a/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
+++ b/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
@@ -22,11 +22,15 @@ import java.io.Serializable;
public class HBaseResponse implements Serializable {
private static final long serialVersionUID = 7263557115683263492L;
+ private String segmentName;
private String tableName;
private long tableSize;
private int regionCount;
private long dateRangeStart;
private long dateRangeEnd;
+ private long sourceOffsetStart;
+ private long sourceOffsetEnd;
+ private long sourceCount;
public HBaseResponse() {
}
@@ -105,4 +109,36 @@ public class HBaseResponse implements Serializable {
public void setDateRangeEnd(long dateRangeEnd) {
this.dateRangeEnd = dateRangeEnd;
}
+
+ public String getSegmentName() {
+ return segmentName;
+ }
+
+ public void setSegmentName(String segmentName) {
+ this.segmentName = segmentName;
+ }
+
+ public long getSourceOffsetStart() {
+ return sourceOffsetStart;
+ }
+
+ public void setSourceOffsetStart(long sourceOffsetStart) {
+ this.sourceOffsetStart = sourceOffsetStart;
+ }
+
+ public long getSourceOffsetEnd() {
+ return sourceOffsetEnd;
+ }
+
+ public void setSourceOffsetEnd(long sourceOffsetEnd) {
+ this.sourceOffsetEnd = sourceOffsetEnd;
+ }
+
+ public long getSourceCount() {
+ return sourceCount;
+ }
+
+ public void setSourceCount(long sourceCount) {
+ this.sourceCount = sourceCount;
+ }
}
[8/8] kylin git commit: KYLIN-1971 refactor ModelDesc to use TableRef
Posted by li...@apache.org.
KYLIN-1971 refactor ModelDesc to use TableRef
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/f1f69d44
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/f1f69d44
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/f1f69d44
Branch: refs/heads/KYLIN-1971
Commit: f1f69d44eb8db9d38774ff8aba948492a4dfce7d
Parents: 3384124
Author: Li Yang <li...@apache.org>
Authored: Wed Sep 28 18:16:15 2016 +0800
Committer: Li Yang <li...@apache.org>
Committed: Fri Oct 21 18:07:00 2016 +0800
----------------------------------------------------------------------
.../org/apache/kylin/cube/model/CubeDesc.java | 2 +-
.../apache/kylin/cube/model/DictionaryDesc.java | 4 +-
.../kylin/cube/model/v1_4_0/CubeDesc.java | 2 +-
.../org/apache/kylin/job/JoinedFlatTable.java | 2 +-
.../kylin/metadata/model/DataModelDesc.java | 151 +-
.../apache/kylin/metadata/model/LookupDesc.java | 25 +-
.../apache/kylin/metadata/model/TableDesc.java | 3 +-
.../apache/kylin/metadata/model/TableRef.java | 99 +
.../apache/kylin/metadata/model/TblColRef.java | 6 +
.../kylin/metadata/MetadataManagerTest.java | 16 +-
examples/sample_cube/create_sample_tables.sql | 19 +-
.../sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv | 244 +
.../sample_cube/data/DEFAULT.KYLIN_SALES.csv | 20000 ++++++++---------
.../template/table/DEFAULT.KYLIN_COUNTRY.json | 24 +
.../template/table/DEFAULT.KYLIN_SALES.json | 26 +-
.../test_kylin_snowflake_model_desc.json | 161 +
.../table/DEFAULT.TEST_KYLIN_COUNTRY.json | 24 +
.../table/DEFAULT.TEST_KYLIN_FACT.json | 8 +
18 files changed, 10732 insertions(+), 10084 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-cube/src/main/java/org/apache/kylin/cube/model/CubeDesc.java
----------------------------------------------------------------------
diff --git a/core-cube/src/main/java/org/apache/kylin/cube/model/CubeDesc.java b/core-cube/src/main/java/org/apache/kylin/cube/model/CubeDesc.java
index bf3724a..7db460e 100644
--- a/core-cube/src/main/java/org/apache/kylin/cube/model/CubeDesc.java
+++ b/core-cube/src/main/java/org/apache/kylin/cube/model/CubeDesc.java
@@ -344,7 +344,7 @@ public class CubeDesc extends RootPersistentEntity implements IEngineAware {
}
public TableDesc getFactTableDesc() {
- return model.getFactTableDesc();
+ return model.getFactTableRef().getTableDesc();
}
public List<TableDesc> getLookupTableDescs() {
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-cube/src/main/java/org/apache/kylin/cube/model/DictionaryDesc.java
----------------------------------------------------------------------
diff --git a/core-cube/src/main/java/org/apache/kylin/cube/model/DictionaryDesc.java b/core-cube/src/main/java/org/apache/kylin/cube/model/DictionaryDesc.java
index f8e3432..f471f9f 100644
--- a/core-cube/src/main/java/org/apache/kylin/cube/model/DictionaryDesc.java
+++ b/core-cube/src/main/java/org/apache/kylin/cube/model/DictionaryDesc.java
@@ -46,11 +46,11 @@ public class DictionaryDesc {
DataModelDesc model = cubeDesc.getModel();
column = column.toUpperCase();
- colRef = model.findColumn(column).getRef();
+ colRef = model.findColumn(column);
if (reuseColumn != null) {
reuseColumn = reuseColumn.toUpperCase();
- reuseColRef = model.findColumn(reuseColumn).getRef();
+ reuseColRef = model.findColumn(reuseColumn);
}
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-cube/src/main/java/org/apache/kylin/cube/model/v1_4_0/CubeDesc.java
----------------------------------------------------------------------
diff --git a/core-cube/src/main/java/org/apache/kylin/cube/model/v1_4_0/CubeDesc.java b/core-cube/src/main/java/org/apache/kylin/cube/model/v1_4_0/CubeDesc.java
index 14aa5f8..760b3e7 100644
--- a/core-cube/src/main/java/org/apache/kylin/cube/model/v1_4_0/CubeDesc.java
+++ b/core-cube/src/main/java/org/apache/kylin/cube/model/v1_4_0/CubeDesc.java
@@ -329,7 +329,7 @@ public class CubeDesc extends RootPersistentEntity {
}
public TableDesc getFactTableDesc() {
- return model.getFactTableDesc();
+ return model.getFactTableRef().getTableDesc();
}
public List<TableDesc> getLookupTableDescs() {
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-job/src/main/java/org/apache/kylin/job/JoinedFlatTable.java
----------------------------------------------------------------------
diff --git a/core-job/src/main/java/org/apache/kylin/job/JoinedFlatTable.java b/core-job/src/main/java/org/apache/kylin/job/JoinedFlatTable.java
index 699d084..3cc27ba 100644
--- a/core-job/src/main/java/org/apache/kylin/job/JoinedFlatTable.java
+++ b/core-job/src/main/java/org/apache/kylin/job/JoinedFlatTable.java
@@ -227,7 +227,7 @@ public class JoinedFlatTable {
List<JoinDesc> result = Lists.newArrayList();
for (LookupDesc lookup : flatDesc.getDataModel().getLookups()) {
- String table = lookup.getTableDesc().getIdentity();
+ String table = lookup.getTableRef().getTableIdentity();
if (usedTableIdentities.contains(table)) {
result.add(lookup.getJoin());
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-metadata/src/main/java/org/apache/kylin/metadata/model/DataModelDesc.java
----------------------------------------------------------------------
diff --git a/core-metadata/src/main/java/org/apache/kylin/metadata/model/DataModelDesc.java b/core-metadata/src/main/java/org/apache/kylin/metadata/model/DataModelDesc.java
index d04830b..aba6380 100644
--- a/core-metadata/src/main/java/org/apache/kylin/metadata/model/DataModelDesc.java
+++ b/core-metadata/src/main/java/org/apache/kylin/metadata/model/DataModelDesc.java
@@ -38,6 +38,7 @@ import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonAutoDetect.Visibility;
import com.fasterxml.jackson.annotation.JsonProperty;
import com.google.common.collect.Lists;
+import com.google.common.collect.Maps;
import com.google.common.collect.Sets;
@SuppressWarnings("serial")
@@ -80,9 +81,11 @@ public class DataModelDesc extends RootPersistentEntity {
@JsonProperty("capacity")
private RealizationCapacity capacity = RealizationCapacity.MEDIUM;
- private TableDesc factTableDesc;
-
- private List<TableDesc> lookupTableDescs = Lists.newArrayList();
+ // computed attributes
+ private TableRef factTableRef;
+ private List<TableRef> lookupTableRefs = Lists.newArrayList();
+ private Map<String, TableRef> aliasMap = Maps.newHashMap(); // a table has exactly one alias
+ private Map<String, TableRef> tableNameMap = Maps.newHashMap(); // a table maybe referenced by multiple names
/**
* Error messages during resolving json metadata
@@ -129,12 +132,21 @@ public class DataModelDesc extends RootPersistentEntity {
return factTable;
}
- public TableDesc getFactTableDesc() {
- return factTableDesc;
+ public TableRef getFactTableRef() {
+ return factTableRef;
}
+ public List<TableRef> getLookupTableRefs() {
+ return lookupTableRefs;
+ }
+
+ @Deprecated
public List<TableDesc> getLookupTableDescs() {
- return lookupTableDescs;
+ List<TableDesc> result = Lists.newArrayList();
+ for (TableRef table : getLookupTableRefs()) {
+ result.add(table.getTableDesc());
+ }
+ return result;
}
public void setFactTable(String factTable) {
@@ -202,77 +214,110 @@ public class DataModelDesc extends RootPersistentEntity {
return candidate;
}
- // TODO let this replace CubeDesc.buildColumnNameAbbreviation()
- public ColumnDesc findColumn(String column) {
- ColumnDesc colDesc = null;
+ public TblColRef findColumn(String table, String column) {
+ TableRef tableRef = findTable(table);
+ TblColRef result = tableRef.getColumn(column);
+ if (result == null)
+ throw new IllegalArgumentException("Column not found by " + table + "." + column);
+ return result;
+ }
+
+ public TblColRef findColumn(String column) {
+ TblColRef result = null;
int cut = column.lastIndexOf('.');
if (cut > 0) {
// table specified
- String table = column.substring(0, cut);
- TableDesc tableDesc = findTable(table);
- colDesc = tableDesc.findColumnByName(column.substring(cut + 1));
+ result = findColumn(column.substring(0, cut), column.substring(cut + 1));
} else {
// table not specified, try each table
- colDesc = factTableDesc.findColumnByName(column);
- if (colDesc == null) {
- for (TableDesc tableDesc : lookupTableDescs) {
- colDesc = tableDesc.findColumnByName(column);
- if (colDesc != null)
+ result = factTableRef.getColumn(column);
+ if (result == null) {
+ for (TableRef tableRef : lookupTableRefs) {
+ result = tableRef.getColumn(column);
+ if (result != null)
break;
}
}
}
- if (colDesc == null)
+ if (result == null)
throw new IllegalArgumentException("Column not found by " + column);
- return colDesc;
+ return result;
}
- public TableDesc findTable(String table) {
- if (factTableDesc.getName().equalsIgnoreCase(table) || factTableDesc.getIdentity().equalsIgnoreCase(table))
- return factTableDesc;
-
- for (TableDesc desc : lookupTableDescs) {
- if (desc.getName().equalsIgnoreCase(table) || desc.getIdentity().equalsIgnoreCase(table))
- return desc;
+ public TableRef findTable(String table) {
+ TableRef result = tableNameMap.get(table);
+ if (result == null) {
+ throw new IllegalArgumentException("Table not found by " + table);
}
-
- throw new IllegalArgumentException("Table not found by " + table);
+ return result;
}
public void init(KylinConfig config, Map<String, TableDesc> tables) {
this.config = config;
- this.factTable = this.factTable.toUpperCase();
- this.factTableDesc = tables.get(this.factTable.toUpperCase());
- if (factTableDesc == null) {
- throw new IllegalStateException("Fact table does not exist:" + this.factTable);
- }
-
+
+ initTableAlias(tables);
initJoinColumns(tables);
ModelDimensionDesc.capicalizeStrings(dimensions);
initPartitionDesc(tables);
}
+ private void initTableAlias(Map<String, TableDesc> tables) {
+ factTable = factTable.toUpperCase();
+
+ if (tables.containsKey(factTable) == false)
+ throw new IllegalStateException("Fact table does not exist:" + factTable);
+
+ factTableRef = new TableRef(this, "FACT", tables.get(factTable));
+ addAlias(factTableRef);
+
+ for (LookupDesc lookup : lookups) {
+ lookup.setTable(lookup.getTable().toUpperCase());
+
+ if (tables.containsKey(lookup.getTable()) == false)
+ throw new IllegalStateException("Lookup table does not exist:" + lookup.getTable());
+
+ String alias = lookup.getAlias();
+ if (alias == null)
+ alias = lookup.getTable();
+ TableRef ref = new TableRef(this, alias, tables.get(lookup.getTable()));
+ lookup.setTableRef(ref);
+ lookupTableRefs.add(ref);
+ addAlias(ref);
+ }
+
+ tableNameMap.putAll(aliasMap);
+ }
+
+ private void addAlias(TableRef ref) {
+ String alias = ref.getAlias();
+ if (aliasMap.containsKey(alias))
+ throw new IllegalStateException("Alias '" + alias + "' ref to multiple tables: " + ref.getTableIdentity() + ", " + aliasMap.get(alias).getTableIdentity());
+ aliasMap.put(alias, ref);
+
+ TableDesc table = ref.getTableDesc();
+ addTableName(table.getName(), ref);
+ addTableName(table.getIdentity(), ref);
+ }
+
+ private void addTableName(String name, TableRef ref) {
+ if (tableNameMap.containsKey(name)) {
+ tableNameMap.put(name, null); // conflict name
+ } else {
+ tableNameMap.put(name, ref);
+ }
+ }
+
private void initPartitionDesc(Map<String, TableDesc> tables) {
if (this.partitionDesc != null)
this.partitionDesc.init(tables);
}
private void initJoinColumns(Map<String, TableDesc> tables) {
- // join columns may or may not present in cube;
- // here we don't modify 'allColumns' and 'dimensionColumns';
- // initDimensionColumns() will do the update
for (LookupDesc lookup : this.lookups) {
- lookup.setTable(lookup.getTable().toUpperCase());
- TableDesc dimTable = tables.get(lookup.getTable());
- if (dimTable == null) {
- throw new IllegalStateException("Table " + lookup.getTable() + " does not exist for " + this);
- }
- lookup.setTableDesc(dimTable);
- this.lookupTableDescs.add(dimTable);
-
+ TableRef dimTable = lookup.getTableRef();
JoinDesc join = lookup.getJoin();
if (join == null)
continue;
@@ -284,13 +329,11 @@ public class DataModelDesc extends RootPersistentEntity {
String[] pks = join.getPrimaryKey();
TblColRef[] pkCols = new TblColRef[pks.length];
for (int i = 0; i < pks.length; i++) {
- ColumnDesc col = dimTable.findColumnByName(pks[i]);
+ TblColRef col = dimTable.getColumn(pks[i]);
if (col == null) {
- throw new IllegalStateException("Can't find column " + pks[i] + " in table " + dimTable.getIdentity());
+ throw new IllegalStateException("Can't find column " + pks[i] + " in table " + dimTable.getTableIdentity());
}
- TblColRef colRef = new TblColRef(col);
- pks[i] = colRef.getName();
- pkCols[i] = colRef;
+ pkCols[i] = col;
}
join.setPrimaryKeyColumns(pkCols);
@@ -298,13 +341,11 @@ public class DataModelDesc extends RootPersistentEntity {
String[] fks = join.getForeignKey();
TblColRef[] fkCols = new TblColRef[fks.length];
for (int i = 0; i < fks.length; i++) {
- ColumnDesc col = factTableDesc.findColumnByName(fks[i]);
+ TblColRef col = factTableRef.getColumn(fks[i]);
if (col == null) {
throw new IllegalStateException("Can't find column " + fks[i] + " in table " + this.getFactTable());
}
- TblColRef colRef = new TblColRef(col);
- fks[i] = colRef.getName();
- fkCols[i] = colRef;
+ fkCols[i] = col;
}
join.setForeignKeyColumns(fkCols);
@@ -314,7 +355,7 @@ public class DataModelDesc extends RootPersistentEntity {
}
for (int i = 0; i < fkCols.length; i++) {
if (!fkCols[i].getDatatype().equals(pkCols[i].getDatatype())) {
- logger.warn("Primary key " + lookup.getTable() + "." + pkCols[i].getName() + "." + pkCols[i].getDatatype() + " are not consistent with Foreign key " + this.getFactTable() + "." + fkCols[i].getName() + "." + fkCols[i].getDatatype());
+ logger.warn("PK " + lookup.getTable() + "." + pkCols[i].getName() + "." + pkCols[i].getDatatype() + " are not consistent with FK " + this.getFactTable() + "." + fkCols[i].getName() + "." + fkCols[i].getDatatype());
}
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-metadata/src/main/java/org/apache/kylin/metadata/model/LookupDesc.java
----------------------------------------------------------------------
diff --git a/core-metadata/src/main/java/org/apache/kylin/metadata/model/LookupDesc.java b/core-metadata/src/main/java/org/apache/kylin/metadata/model/LookupDesc.java
index c85612a..b8828f7 100644
--- a/core-metadata/src/main/java/org/apache/kylin/metadata/model/LookupDesc.java
+++ b/core-metadata/src/main/java/org/apache/kylin/metadata/model/LookupDesc.java
@@ -19,6 +19,7 @@
package org.apache.kylin.metadata.model;
import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonInclude;
import com.fasterxml.jackson.annotation.JsonAutoDetect.Visibility;
import com.fasterxml.jackson.annotation.JsonProperty;
@@ -28,33 +29,37 @@ public class LookupDesc {
@JsonProperty("table")
private String table;
+ @JsonProperty("alias")
+ @JsonInclude(JsonInclude.Include.NON_NULL)
+ private String alias;
+
@JsonProperty("join")
private JoinDesc join;
- private TableDesc tableDesc;
+ private TableRef tableRef;
public String getTable() {
return table;
}
- public void setTable(String table) {
+ void setTable(String table) {
this.table = table;
}
+ public String getAlias() {
+ return alias;
+ }
+
public JoinDesc getJoin() {
return join;
}
- public void setJoin(JoinDesc join) {
- this.join = join;
+ public TableRef getTableRef() {
+ return tableRef;
}
- public TableDesc getTableDesc() {
- return tableDesc;
- }
-
- void setTableDesc(TableDesc tableDesc) {
- this.tableDesc = tableDesc;
+ void setTableRef(TableRef ref) {
+ this.tableRef = ref;
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableDesc.java
----------------------------------------------------------------------
diff --git a/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableDesc.java b/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableDesc.java
index e163d1d..659de07 100644
--- a/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableDesc.java
+++ b/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableDesc.java
@@ -211,8 +211,7 @@ public class TableDesc extends RootPersistentEntity implements ISourceAware {
return false;
if (!Arrays.equals(columns, tableDesc.columns))
return false;
- // if (tableType != null ? !tableType.equals(tableDesc.tableType) : tableDesc.tableType != null)
- // return false;
+
return getIdentity().equals(tableDesc.getIdentity());
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableRef.java
----------------------------------------------------------------------
diff --git a/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableRef.java b/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableRef.java
new file mode 100644
index 0000000..afe25fd
--- /dev/null
+++ b/core-metadata/src/main/java/org/apache/kylin/metadata/model/TableRef.java
@@ -0,0 +1,99 @@
+/*
+ * 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.kylin.metadata.model;
+
+import java.util.Map;
+
+import com.google.common.collect.Maps;
+
+public class TableRef {
+
+ final DataModelDesc model;
+ final String alias;
+ final TableDesc table;
+ final Map<String, TblColRef> columns;
+
+ TableRef(DataModelDesc model, String alias, TableDesc table) {
+ this.model = model;
+ this.alias = alias;
+ this.table = table;
+ this.columns = Maps.newLinkedHashMap();
+
+ for (ColumnDesc col : table.getColumns()) {
+ columns.put(col.getName(), new TblColRef(this, col));
+ }
+ }
+
+ public DataModelDesc getModel() {
+ return model;
+ }
+
+ public String getAlias() {
+ return alias;
+ }
+
+ public TableDesc getTableDesc() {
+ return table;
+ }
+
+ public String getTableName() {
+ return table.getName();
+ }
+
+ public String getTableIdentity() {
+ return table.getIdentity();
+ }
+
+ public TblColRef getColumn(String name) {
+ return columns.get(name);
+ }
+
+ @Override
+ public boolean equals(Object o) {
+ if (this == o)
+ return true;
+ if (o == null || getClass() != o.getClass())
+ return false;
+
+ TableRef t = (TableRef) o;
+
+ if (!model.equals(t.model))
+ return false;
+ if (!alias.equals(t.alias))
+ return false;
+ if (!table.getIdentity().equals(t.table.getIdentity()))
+ return false;
+
+ return true;
+ }
+
+ @Override
+ public int hashCode() {
+ int result = 0;
+ result = 31 * result + model.getName().hashCode();
+ result = 31 * result + alias.hashCode();
+ result = 31 * result + table.getIdentity().hashCode();
+ return result;
+ }
+
+ @Override
+ public String toString() {
+ return "TableRef[" + alias + "." + table.getName() + "]";
+ }
+}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-metadata/src/main/java/org/apache/kylin/metadata/model/TblColRef.java
----------------------------------------------------------------------
diff --git a/core-metadata/src/main/java/org/apache/kylin/metadata/model/TblColRef.java b/core-metadata/src/main/java/org/apache/kylin/metadata/model/TblColRef.java
index 2764747..0f3f70d 100644
--- a/core-metadata/src/main/java/org/apache/kylin/metadata/model/TblColRef.java
+++ b/core-metadata/src/main/java/org/apache/kylin/metadata/model/TblColRef.java
@@ -63,11 +63,17 @@ public class TblColRef implements Serializable {
// ============================================================================
+ private TableRef table;
private ColumnDesc column;
TblColRef(ColumnDesc column) {
this.column = column;
}
+
+ TblColRef(TableRef table, ColumnDesc column) {
+ this.table = table;
+ this.column = column;
+ }
public ColumnDesc getColumnDesc() {
return column;
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/core-metadata/src/test/java/org/apache/kylin/metadata/MetadataManagerTest.java
----------------------------------------------------------------------
diff --git a/core-metadata/src/test/java/org/apache/kylin/metadata/MetadataManagerTest.java b/core-metadata/src/test/java/org/apache/kylin/metadata/MetadataManagerTest.java
index a4977c4..5f215f1 100644
--- a/core-metadata/src/test/java/org/apache/kylin/metadata/MetadataManagerTest.java
+++ b/core-metadata/src/test/java/org/apache/kylin/metadata/MetadataManagerTest.java
@@ -68,7 +68,21 @@ public class MetadataManagerTest extends LocalFileMetadataTestCase {
@Test
public void testDataModel() throws Exception {
DataModelDesc modelDesc = getInstance(getTestConfig()).getDataModelDesc("test_kylin_left_join_model_desc");
-
Assert.assertTrue(modelDesc.getDimensions().size() > 0);
}
+
+ @Test
+ public void testSnowflakeDataModel() throws Exception {
+ DataModelDesc model = getInstance(getTestConfig()).getDataModelDesc("test_kylin_snowflake_model_desc");
+ Assert.assertTrue(model.getDimensions().size() > 0);
+
+ try {
+ model.findTable("TEST_KYLIN_COUNTRY");
+ Assert.fail();
+ } catch (IllegalArgumentException ex) {
+ // excepted
+ }
+ Assert.assertNotNull(model.findColumn("BUYER_COUNTRY"));
+ Assert.assertNotNull(model.findColumn("SELLER_COUNTRY"));
+ }
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/sample_cube/create_sample_tables.sql
----------------------------------------------------------------------
diff --git a/examples/sample_cube/create_sample_tables.sql b/examples/sample_cube/create_sample_tables.sql
index 9fa17d7..2001e76 100644
--- a/examples/sample_cube/create_sample_tables.sql
+++ b/examples/sample_cube/create_sample_tables.sql
@@ -170,6 +170,18 @@ COMMENT 'Detail category inforamtion, Dimension Table'
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE;
+DROP TABLE IF EXISTS DEFAULT.KYLIN_COUNTRY;
+
+CREATE TABLE DEFAULT.KYLIN_COUNTRY
+(
+COUNTRY string
+,LATITUDE double
+,LONGITUDE double
+,NAME string
+)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
+STORED AS TEXTFILE;
+
DROP TABLE IF EXISTS DEFAULT.KYLIN_SALES;
CREATE TABLE DEFAULT.KYLIN_SALES
@@ -183,13 +195,16 @@ TRANS_ID bigint
,PRICE decimal(19,4) COMMENT 'Order Price'
,ITEM_COUNT bigint COMMENT 'Number of Purchased Goods'
,SELLER_ID bigint COMMENT 'Seller ID'
-,USER_ID string COMMENT 'USER ID'
-,REGION string COMMENT 'REGION'
+,BUYER_COUNTRY string 'Buyer Country'
+,SELLER_COUNTRY string 'Seller Country'
+,USER_ID string COMMENT 'System User ID'
+,REGION string COMMENT 'System User Region'
)
COMMENT 'Sales order table, fact table'
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE;
LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_SALES.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_SALES;
+LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_COUNTRY;
LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CAL_DT.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_CAL_DT;
LOAD DATA INPATH '/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CATEGORY_GROUPINGS.csv' OVERWRITE INTO TABLE DEFAULT.KYLIN_CATEGORY_GROUPINGS;
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv
----------------------------------------------------------------------
diff --git a/examples/sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv b/examples/sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv
new file mode 100644
index 0000000..aced0e3
--- /dev/null
+++ b/examples/sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv
@@ -0,0 +1,244 @@
+AD,42.546245,1.601554,Andorra
+AE,23.424076,53.847818,United Arab Emirates
+AF,33.93911,67.709953,Afghanistan
+AG,17.060816,-61.796428,Antigua and Barbuda
+AI,18.220554,-63.068615,Anguilla
+AL,41.153332,20.168331,Albania
+AM,40.069099,45.038189,Armenia
+AN,12.226079,-69.060087,Netherlands Antilles
+AO,-11.202692,17.873887,Angola
+AQ,-75.250973,-0.071389,Antarctica
+AR,-38.416097,-63.616672,Argentina
+AS,-14.270972,-170.132217,American Samoa
+AT,47.516231,14.550072,Austria
+AU,-25.274398,133.775136,Australia
+AW,12.52111,-69.968338,Aruba
+AZ,40.143105,47.576927,Azerbaijan
+BA,43.915886,17.679076,Bosnia and Herzegovina
+BB,13.193887,-59.543198,Barbados
+BD,23.684994,90.356331,Bangladesh
+BE,50.503887,4.469936,Belgium
+BF,12.238333,-1.561593,Burkina Faso
+BG,42.733883,25.48583,Bulgaria
+BH,25.930414,50.637772,Bahrain
+BI,-3.373056,29.918886,Burundi
+BJ,9.30769,2.315834,Benin
+BM,32.321384,-64.75737,Bermuda
+BN,4.535277,114.727669,Brunei
+BO,-16.290154,-63.588653,Bolivia
+BR,-14.235004,-51.92528,Brazil
+BS,25.03428,-77.39628,Bahamas
+BT,27.514162,90.433601,Bhutan
+BV,-54.423199,3.413194,Bouvet Island
+BW,-22.328474,24.684866,Botswana
+BY,53.709807,27.953389,Belarus
+BZ,17.189877,-88.49765,Belize
+CA,56.130366,-106.346771,Canada
+CC,-12.164165,96.870956,Cocos [Keeling] Islands
+CD,-4.038333,21.758664,Congo [DRC]
+CF,6.611111,20.939444,Central African Republic
+CG,-0.228021,15.827659,Congo [Republic]
+CH,46.818188,8.227512,Switzerland
+CI,7.539989,-5.54708,C?te d'Ivoire
+CK,-21.236736,-159.777671,Cook Islands
+CL,-35.675147,-71.542969,Chile
+CM,7.369722,12.354722,Cameroon
+CN,35.86166,104.195397,China
+CO,4.570868,-74.297333,Colombia
+CR,9.748917,-83.753428,Costa Rica
+CU,21.521757,-77.781167,Cuba
+CV,16.002082,-24.013197,Cape Verde
+CX,-10.447525,105.690449,Christmas Island
+CY,35.126413,33.429859,Cyprus
+CZ,49.817492,15.472962,Czech Republic
+DE,51.165691,10.451526,Germany
+DJ,11.825138,42.590275,Djibouti
+DK,56.26392,9.501785,Denmark
+DM,15.414999,-61.370976,Dominica
+DO,18.735693,-70.162651,Dominican Republic
+DZ,28.033886,1.659626,Algeria
+EC,-1.831239,-78.183406,Ecuador
+EE,58.595272,25.013607,Estonia
+EG,26.820553,30.802498,Egypt
+EH,24.215527,-12.885834,Western Sahara
+ER,15.179384,39.782334,Eritrea
+ES,40.463667,-3.74922,Spain
+ET,9.145,40.489673,Ethiopia
+FI,61.92411,25.748151,Finland
+FJ,-16.578193,179.414413,Fiji
+FK,-51.796253,-59.523613,Falkland Islands [Islas Malvinas]
+FM,7.425554,150.550812,Micronesia
+FO,61.892635,-6.911806,Faroe Islands
+FR,46.227638,2.213749,France
+GA,-0.803689,11.609444,Gabon
+GB,55.378051,-3.435973,United Kingdom
+GD,12.262776,-61.604171,Grenada
+GE,42.315407,43.356892,Georgia
+GF,3.933889,-53.125782,French Guiana
+GG,49.465691,-2.585278,Guernsey
+GH,7.946527,-1.023194,Ghana
+GI,36.137741,-5.345374,Gibraltar
+GL,71.706936,-42.604303,Greenland
+GM,13.443182,-15.310139,Gambia
+GN,9.945587,-9.696645,Guinea
+GP,16.995971,-62.067641,Guadeloupe
+GQ,1.650801,10.267895,Equatorial Guinea
+GR,39.074208,21.824312,Greece
+GS,-54.429579,-36.587909,South Georgia and the South Sandwich Islands
+GT,15.783471,-90.230759,Guatemala
+GU,13.444304,144.793731,Guam
+GW,11.803749,-15.180413,Guinea-Bissau
+GY,4.860416,-58.93018,Guyana
+GZ,31.354676,34.308825,Gaza Strip
+HK,22.396428,114.109497,Hong Kong
+HM,-53.08181,73.504158,Heard Island and McDonald Islands
+HN,15.199999,-86.241905,Honduras
+HR,45.1,15.2,Croatia
+HT,18.971187,-72.285215,Haiti
+HU,47.162494,19.503304,Hungary
+ID,-0.789275,113.921327,Indonesia
+IE,53.41291,-8.24389,Ireland
+IL,31.046051,34.851612,Israel
+IM,54.236107,-4.548056,Isle of Man
+IN,20.593684,78.96288,India
+IO,-6.343194,71.876519,British Indian Ocean Territory
+IQ,33.223191,43.679291,Iraq
+IR,32.427908,53.688046,Iran
+IS,64.963051,-19.020835,Iceland
+IT,41.87194,12.56738,Italy
+JE,49.214439,-2.13125,Jersey
+JM,18.109581,-77.297508,Jamaica
+JO,30.585164,36.238414,Jordan
+JP,36.204824,138.252924,Japan
+KE,-0.023559,37.906193,Kenya
+KG,41.20438,74.766098,Kyrgyzstan
+KH,12.565679,104.990963,Cambodia
+KI,-3.370417,-168.734039,Kiribati
+KM,-11.875001,43.872219,Comoros
+KN,17.357822,-62.782998,Saint Kitts and Nevis
+KP,40.339852,127.510093,North Korea
+KR,35.907757,127.766922,South Korea
+KW,29.31166,47.481766,Kuwait
+KY,19.513469,-80.566956,Cayman Islands
+KZ,48.019573,66.923684,Kazakhstan
+LA,19.85627,102.495496,Laos
+LB,33.854721,35.862285,Lebanon
+LC,13.909444,-60.978893,Saint Lucia
+LI,47.166,9.555373,Liechtenstein
+LK,7.873054,80.771797,Sri Lanka
+LR,6.428055,-9.429499,Liberia
+LS,-29.609988,28.233608,Lesotho
+LT,55.169438,23.881275,Lithuania
+LU,49.815273,6.129583,Luxembourg
+LV,56.879635,24.603189,Latvia
+LY,26.3351,17.228331,Libya
+MA,31.791702,-7.09262,Morocco
+MC,43.750298,7.412841,Monaco
+MD,47.411631,28.369885,Moldova
+ME,42.708678,19.37439,Montenegro
+MG,-18.766947,46.869107,Madagascar
+MH,7.131474,171.184478,Marshall Islands
+MK,41.608635,21.745275,Macedonia [FYROM]
+ML,17.570692,-3.996166,Mali
+MM,21.913965,95.956223,Myanmar [Burma]
+MN,46.862496,103.846656,Mongolia
+MO,22.198745,113.543873,Macau
+MP,17.33083,145.38469,Northern Mariana Islands
+MQ,14.641528,-61.024174,Martinique
+MR,21.00789,-10.940835,Mauritania
+MS,16.742498,-62.187366,Montserrat
+MT,35.937496,14.375416,Malta
+MU,-20.348404,57.552152,Mauritius
+MV,3.202778,73.22068,Maldives
+MW,-13.254308,34.301525,Malawi
+MX,23.634501,-102.552784,Mexico
+MY,4.210484,101.975766,Malaysia
+MZ,-18.665695,35.529562,Mozambique
+NA,-22.95764,18.49041,Namibia
+NC,-20.904305,165.618042,New Caledonia
+NE,17.607789,8.081666,Niger
+NF,-29.040835,167.954712,Norfolk Island
+NG,9.081999,8.675277,Nigeria
+NI,12.865416,-85.207229,Nicaragua
+NL,52.132633,5.291266,Netherlands
+NO,60.472024,8.468946,Norway
+NP,28.394857,84.124008,Nepal
+NR,-0.522778,166.931503,Nauru
+NU,-19.054445,-169.867233,Niue
+NZ,-40.900557,174.885971,New Zealand
+OM,21.512583,55.923255,Oman
+PA,8.537981,-80.782127,Panama
+PE,-9.189967,-75.015152,Peru
+PF,-17.679742,-149.406843,French Polynesia
+PG,-6.314993,143.95555,Papua New Guinea
+PH,12.879721,121.774017,Philippines
+PK,30.375321,69.345116,Pakistan
+PL,51.919438,19.145136,Poland
+PM,46.941936,-56.27111,Saint Pierre and Miquelon
+PN,-24.703615,-127.439308,Pitcairn Islands
+PR,18.220833,-66.590149,Puerto Rico
+PS,31.952162,35.233154,Palestinian Territories
+PT,39.399872,-8.224454,Portugal
+PW,7.51498,134.58252,Palau
+PY,-23.442503,-58.443832,Paraguay
+QA,25.354826,51.183884,Qatar
+RE,-21.115141,55.536384,R\ufffd\ufffdunion
+RO,45.943161,24.96676,Romania
+RS,44.016521,21.005859,Serbia
+RU,61.52401,105.318756,Russia
+RW,-1.940278,29.873888,Rwanda
+SA,23.885942,45.079162,Saudi Arabia
+SB,-9.64571,160.156194,Solomon Islands
+SC,-4.679574,55.491977,Seychelles
+SD,12.862807,30.217636,Sudan
+SE,60.128161,18.643501,Sweden
+SG,1.352083,103.819836,Singapore
+SH,-24.143474,-10.030696,Saint Helena
+SI,46.151241,14.995463,Slovenia
+SJ,77.553604,23.670272,Svalbard and Jan Mayen
+SK,48.669026,19.699024,Slovakia
+SL,8.460555,-11.779889,Sierra Leone
+SM,43.94236,12.457777,San Marino
+SN,14.497401,-14.452362,Senegal
+SO,5.152149,46.199616,Somalia
+SR,3.919305,-56.027783,Suriname
+ST,0.18636,6.613081,S?o Tom\ufffd\ufffd and Pr\ufffd\ufffdncipe
+SV,13.794185,-88.89653,El Salvador
+SY,34.802075,38.996815,Syria
+SZ,-26.522503,31.465866,Swaziland
+TC,21.694025,-71.797928,Turks and Caicos Islands
+TD,15.454166,18.732207,Chad
+TF,-49.280366,69.348557,French Southern Territories
+TG,8.619543,0.824782,Togo
+TH,15.870032,100.992541,Thailand
+TJ,38.861034,71.276093,Tajikistan
+TK,-8.967363,-171.855881,Tokelau
+TL,-8.874217,125.727539,Timor-Leste
+TM,38.969719,59.556278,Turkmenistan
+TN,33.886917,9.537499,Tunisia
+TO,-21.178986,-175.198242,Tonga
+TR,38.963745,35.243322,Turkey
+TT,10.691803,-61.222503,Trinidad and Tobago
+TV,-7.109535,177.64933,Tuvalu
+TW,23.69781,120.960515,Taiwan
+TZ,-6.369028,34.888822,Tanzania
+UA,48.379433,31.16558,Ukraine
+UG,1.373333,32.290275,Uganda
+US,37.09024,-95.712891,United States
+UY,-32.522779,-55.765835,Uruguay
+UZ,41.377491,64.585262,Uzbekistan
+VA,41.902916,12.453389,Vatican City
+VC,12.984305,-61.287228,Saint Vincent and the Grenadines
+VE,6.42375,-66.58973,Venezuela
+VG,18.420695,-64.639968,British Virgin Islands
+VI,18.335765,-64.896335,U.S. Virgin Islands
+VN,14.058324,108.277199,Vietnam
+VU,-15.376706,166.959158,Vanuatu
+WF,-13.768752,-177.156097,Wallis and Futuna
+WS,-13.759029,-172.104629,Samoa
+XK,42.602636,20.902977,Kosovo
+YE,15.552727,48.516388,Yemen
+YT,-12.8275,45.166244,Mayotte
+ZA,-30.559482,22.937506,South Africa
+ZM,-13.133897,27.849332,Zambia
+ZW,-19.015438,29.154857,Zimbabwe
[4/8] kylin git commit: KYLIN-2091 Add API to init the start-point
(of each parition) for streaming cube
Posted by li...@apache.org.
KYLIN-2091 Add API to init the start-point (of each parition) for streaming cube
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/2d49c88d
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/2d49c88d
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/2d49c88d
Branch: refs/heads/KYLIN-1971
Commit: 2d49c88d1326bd31a22e0d3bd4a3042adcf81994
Parents: 325803d
Author: shaofengshi <sh...@apache.org>
Authored: Fri Oct 21 14:53:37 2016 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Fri Oct 21 14:53:37 2016 +0800
----------------------------------------------------------------------
.../kylin/rest/controller/CubeController.java | 39 ++++++++++++++++++++
.../rest/controller/CubeDescController.java | 36 ------------------
2 files changed, 39 insertions(+), 36 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/2d49c88d/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
----------------------------------------------------------------------
diff --git a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
index e1ee85d..dd10123 100644
--- a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
+++ b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
@@ -40,6 +40,7 @@ import org.apache.kylin.engine.EngineFactory;
import org.apache.kylin.job.JobInstance;
import org.apache.kylin.job.JoinedFlatTable;
import org.apache.kylin.metadata.model.IJoinedFlatTableDesc;
+import org.apache.kylin.metadata.model.ISourceAware;
import org.apache.kylin.metadata.model.SegmentStatusEnum;
import org.apache.kylin.metadata.project.ProjectInstance;
import org.apache.kylin.metadata.realization.RealizationStatusEnum;
@@ -54,6 +55,7 @@ import org.apache.kylin.rest.response.GeneralResponse;
import org.apache.kylin.rest.response.HBaseResponse;
import org.apache.kylin.rest.service.CubeService;
import org.apache.kylin.rest.service.JobService;
+import org.apache.kylin.source.kafka.util.KafkaClient;
import org.apache.kylin.storage.hbase.cube.v1.coprocessor.observer.ObserverEnabler;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
@@ -607,6 +609,43 @@ public class CubeController extends BasicController {
}
+
+ /**
+ * Initiate the very beginning of a streaming cube. Will seek the latest offests of each partition from streaming
+ * source (kafka) and record in the cube descriptor; In the first build job, it will use these offests as the start point.
+ * @param cubeName
+ * @return
+ */
+ @RequestMapping(value = "/{cubeName}/init_start_offsets", method = { RequestMethod.PUT })
+ @ResponseBody
+ public GeneralResponse initStartOffsets(@PathVariable String cubeName) {
+ CubeInstance cubeInstance = cubeService.getCubeManager().getCube(cubeName);
+
+ String msg = "";
+ if (cubeInstance == null) {
+ msg = "Cube '" + cubeName + "' not found.";
+ throw new IllegalArgumentException(msg);
+ }
+ if (cubeInstance.getSourceType() != ISourceAware.ID_STREAMING) {
+ msg = "Cube '" + cubeName + "' is not a Streaming Cube.";
+ throw new IllegalArgumentException(msg);
+ }
+
+ final GeneralResponse response = new GeneralResponse();
+ try {
+ final Map<Integer, Long> startOffsets = KafkaClient.getCurrentOffsets(cubeInstance);
+ CubeDesc desc = cubeInstance.getDescriptor();
+ desc.setPartitionOffsetStart(startOffsets);
+ cubeService.getCubeDescManager().updateCubeDesc(desc);
+ response.setProperty("result", "success");
+ response.setProperty("offsets", startOffsets.toString());
+ } catch (Exception e) {
+ throw new RuntimeException(e);
+ }
+
+ return response;
+ }
+
private CubeDesc deserializeCubeDesc(CubeRequest cubeRequest) {
CubeDesc desc = null;
try {
http://git-wip-us.apache.org/repos/asf/kylin/blob/2d49c88d/server-base/src/main/java/org/apache/kylin/rest/controller/CubeDescController.java
----------------------------------------------------------------------
diff --git a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeDescController.java b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeDescController.java
index b7eaddd..fc4c694 100644
--- a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeDescController.java
+++ b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeDescController.java
@@ -92,42 +92,6 @@ public class CubeDescController extends BasicController {
}
}
- /**
- * Initiate the very beginning of a streaming cube. Will seek the latest offests of each partition from streaming
- * source (kafka) and record in the cube descriptor; In the first build job, it will use these offests as the start point.
- * @param cubeName
- * @return
- */
- @RequestMapping(value = "/{cubeName}/initStartOffsets", method = { RequestMethod.PUT })
- @ResponseBody
- public GeneralResponse initStartOffsets(@PathVariable String cubeName) {
- CubeInstance cubeInstance = cubeService.getCubeManager().getCube(cubeName);
-
- String msg = "";
- if (cubeInstance == null) {
- msg = "Cube '" + cubeName + "' not found.";
- throw new IllegalArgumentException(msg);
- }
- if (cubeInstance.getSourceType() != ISourceAware.ID_STREAMING) {
- msg = "Cube '" + cubeName + "' is not a Streaming Cube.";
- throw new IllegalArgumentException(msg);
- }
-
- final GeneralResponse response = new GeneralResponse();
- try {
- final Map<Integer, Long> startOffsets = KafkaClient.getCurrentOffsets(cubeInstance);
- CubeDesc desc = cubeInstance.getDescriptor();
- desc.setPartitionOffsetStart(startOffsets);
- cubeService.getCubeDescManager().updateCubeDesc(desc);
- response.setProperty("result", "success");
- response.setProperty("offsets", startOffsets.toString());
- } catch (Exception e) {
- throw new RuntimeException(e);
- }
-
- return response;
- }
-
public void setCubeService(CubeService cubeService) {
this.cubeService = cubeService;
}
[5/8] kylin git commit: KYLIN-2118 allow user view CubeInstance json
even cube is ready
Posted by li...@apache.org.
KYLIN-2118 allow user view CubeInstance json even cube is ready
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/33841245
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/33841245
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/33841245
Branch: refs/heads/KYLIN-1971
Commit: 338412454cf61399ee78befe1cb30bca0ecc6346
Parents: 2d49c88
Author: Jason <ji...@163.com>
Authored: Fri Oct 21 16:30:56 2016 +0800
Committer: Jason <ji...@163.com>
Committed: Fri Oct 21 16:31:29 2016 +0800
----------------------------------------------------------------------
webapp/app/partials/cubes/cube_json_edit.html | 4 ++++
webapp/app/partials/cubes/cube_json_view.html | 4 ++++
webapp/app/partials/cubes/cubes.html | 2 +-
3 files changed, 9 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/33841245/webapp/app/partials/cubes/cube_json_edit.html
----------------------------------------------------------------------
diff --git a/webapp/app/partials/cubes/cube_json_edit.html b/webapp/app/partials/cubes/cube_json_edit.html
index 56baa3e..ac08d1d 100644
--- a/webapp/app/partials/cubes/cube_json_edit.html
+++ b/webapp/app/partials/cubes/cube_json_edit.html
@@ -23,6 +23,10 @@
</div>
<div class="col-xs-9">
<form role="form" name="cube_form" novalidate>
+ <ul class="breadcrumb">
+ <li><a href="#">Model</a></li>
+ <li class="active">Edit CubeDesc</li>
+ </ul>
<section style="padding-bottom: 20px">
<div style="height: 620px; font-size: 14px;" ui-ace="{
useWrapMode : true,
http://git-wip-us.apache.org/repos/asf/kylin/blob/33841245/webapp/app/partials/cubes/cube_json_view.html
----------------------------------------------------------------------
diff --git a/webapp/app/partials/cubes/cube_json_view.html b/webapp/app/partials/cubes/cube_json_view.html
index b353d49..f9c2716 100644
--- a/webapp/app/partials/cubes/cube_json_view.html
+++ b/webapp/app/partials/cubes/cube_json_view.html
@@ -23,6 +23,10 @@
</div>
<div class="col-xs-9">
<form role="form" name="cube_form" novalidate>
+ <ul class="breadcrumb">
+ <li><a href="#">Model</a></li>
+ <li class="active">View CubeDesc</li>
+ </ul>
<section style="padding-bottom: 20px">
<div style="height: 620px; font-size: 14px;" ui-ace="{
useWrapMode : true,
http://git-wip-us.apache.org/repos/asf/kylin/blob/33841245/webapp/app/partials/cubes/cubes.html
----------------------------------------------------------------------
diff --git a/webapp/app/partials/cubes/cubes.html b/webapp/app/partials/cubes/cubes.html
index de9b99b..7b3a533 100644
--- a/webapp/app/partials/cubes/cubes.html
+++ b/webapp/app/partials/cubes/cubes.html
@@ -115,7 +115,7 @@
</button>
<ul class="dropdown-menu" role="menu">
<li ng-if="cube.status!='READY'"><a href="cubes/edit/{{cube.name}}/descriptionjson">Edit CubeDesc</a></li>
- <li ng-if="cube.status!='READY'"><a href="cubes/view/{{cube.name}}/instancejson">View Cube</a></li>
+ <li><a href="cubes/view/{{cube.name}}/instancejson">View Cube</a></li>
</ul>
</div>
</td>
[7/8] kylin git commit: KYLIN-1971 refactor ModelDesc to use TableRef
Posted by li...@apache.org.
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
----------------------------------------------------------------------
diff --git a/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv b/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
index dffa43b..79528f3 100644
--- a/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
+++ b/examples/sample_cube/data/DEFAULT.KYLIN_SALES.csv
@@ -1,10000 +1,10000 @@
-0,2012-12-14,Others,88750,0,11,36.2828,0,10000349,ANALYST,Beijing
-0,2012-08-28,Others,175750,0,13,23.8563,0,10000927,ANALYST,Beijing
-0,2012-02-16,ABIN,148324,15,13,88.3418,0,10000005,ADMIN,Shanghai
-0,2013-10-19,FP-non GTC,37831,0,13,47.3015,0,10000209,ANALYST,Beijing
-0,2012-10-22,Others,140746,100,11,83.4540,0,10000154,ADMIN,Shanghai
-0,2013-01-25,FP-GTC,16509,0,-99,22.9896,0,10000372,ADMIN,Shanghai
-0,2013-04-04,Others,963,0,13,88.5907,0,10000648,MODELER,Hongkong
-0,2012-04-11,Others,15687,0,15,88.1940,0,10000866,ADMIN,Shanghai
-0,2013-01-19,ABIN,60606,3,13,77.9727,0,10000936,MODELER,Hongkong
-0,2012-04-30,FP-non GTC,106246,0,14,52.2950,0,10000047,MODELER,Hongkong
-0,2013-02-03,Auction,45333,0,16,56.3584,0,10000470,MODELER,Hongkong
-0,2012-09-02,FP-GTC,25147,0,-99,15.3553,0,10000203,ANALYST,Beijing
-0,2013-07-30,Others,24760,0,16,25.0770,0,10000382,ADMIN,Shanghai
-0,2012-04-17,Auction,31519,0,16,72.7384,0,10000069,ADMIN,Shanghai
-0,2013-04-30,FP-GTC,51582,0,15,75.8200,0,10000085,ANALYST,Beijing
-0,2013-03-23,FP-GTC,16509,0,15,8.6653,0,10000559,MODELER,Hongkong
-0,2013-04-01,ABIN,175750,3,16,64.2802,0,10000507,MODELER,Hongkong
-0,2013-07-12,ABIN,50677,0,-99,24.5987,0,10000938,ADMIN,Shanghai
-0,2012-04-23,FP-GTC,45333,0,5,72.6553,0,10000863,MODELER,Hongkong
-0,2012-12-19,ABIN,3838,0,12,87.4142,0,10000612,ADMIN,Shanghai
-0,2012-08-15,FP-GTC,62179,0,16,67.4238,0,10000839,MODELER,Hongkong
-0,2013-08-22,Auction,1357,0,5,18.3600,0,10000303,ANALYST,Beijing
-0,2013-08-23,ABIN,31519,0,5,67.6344,0,10000877,ANALYST,Beijing
-0,2013-09-12,FP-GTC,223,0,14,71.7898,0,10000848,MODELER,Hongkong
-0,2012-03-14,FP-GTC,132939,0,15,26.1496,0,10000815,MODELER,Hongkong
-0,2013-07-13,Others,67703,3,16,83.9661,0,10000858,MODELER,Hongkong
-0,2013-12-15,FP-non GTC,100847,0,5,34.3451,0,10000387,ADMIN,Shanghai
-0,2012-08-30,Auction,62179,0,11,21.0496,0,10000393,ANALYST,Beijing
-0,2013-01-10,FP-GTC,48027,0,13,23.4142,0,10000757,MODELER,Hongkong
-0,2013-01-25,ABIN,145970,0,5,26.7842,0,10000402,ANALYST,Beijing
-0,2012-07-05,Auction,48027,0,-99,46.7320,0,10000972,MODELER,Hongkong
-0,2012-11-07,FP-GTC,20213,0,-99,19.7270,0,10000873,ANALYST,Beijing
-0,2013-06-20,ABIN,100847,0,5,76.2783,0,10000409,ADMIN,Shanghai
-0,2012-10-08,ABIN,26262,0,5,48.7447,0,10000029,ADMIN,Shanghai
-0,2013-04-30,ABIN,87118,0,15,63.2187,0,10000529,ANALYST,Beijing
-0,2013-04-24,FP-non GTC,20213,0,16,39.5057,0,10000329,ANALYST,Beijing
-0,2012-05-13,Others,164261,0,13,84.1246,0,10000688,ADMIN,Shanghai
-0,2013-08-02,ABIN,31519,0,5,37.1504,0,10000905,MODELER,Hongkong
-0,2012-04-03,Auction,164261,0,11,92.0974,0,10000341,ADMIN,Shanghai
-0,2012-09-02,FP-GTC,31519,0,14,87.7829,0,10000460,ANALYST,Beijing
-0,2013-10-05,ABIN,13987,0,16,74.0719,0,10000381,MODELER,Hongkong
-0,2012-01-13,FP-GTC,48027,0,15,71.2637,0,10000915,ADMIN,Shanghai
-0,2013-03-01,Others,13836,0,14,16.7288,0,10000953,ADMIN,Shanghai
-0,2012-09-12,FP-non GTC,16509,0,5,12.2933,0,10000277,MODELER,Hongkong
-0,2012-02-07,Auction,45333,0,5,64.9770,0,10000040,MODELER,Hongkong
-0,2013-12-14,FP-non GTC,158798,0,16,72.4413,0,10000500,MODELER,Hongkong
-0,2013-10-13,Auction,31519,0,5,79.3053,0,10000816,MODELER,Hongkong
-0,2012-06-11,ABIN,4943,0,5,11.6942,0,10000696,ANALYST,Beijing
-0,2012-10-18,ABIN,80053,0,-99,54.0933,0,10000604,MODELER,Hongkong
-0,2012-11-03,Auction,20886,0,5,9.8258,0,10000764,MODELER,Hongkong
-0,2012-01-15,Auction,44079,0,14,13.0371,0,10000343,MODELER,Hongkong
-0,2012-07-03,FP-GTC,159184,0,-99,92.5314,0,10000724,ADMIN,Shanghai
-0,2012-02-16,FP-GTC,314,0,13,49.1825,0,10000334,ADMIN,Shanghai
-0,2012-06-17,FP-non GTC,31387,3,12,0.6677,0,10000603,ANALYST,Beijing
-0,2012-07-15,FP-non GTC,32876,0,-99,50.9634,0,10000248,ANALYST,Beijing
-0,2012-07-24,FP-GTC,150265,15,16,57.5645,0,10000653,ADMIN,Shanghai
-0,2012-10-06,Auction,145970,0,5,44.3091,0,10000082,ADMIN,Shanghai
-0,2013-06-14,ABIN,80053,0,5,20.2388,0,10000632,MODELER,Hongkong
-0,2013-10-10,FP-non GTC,15868,0,11,28.6290,0,10000523,MODELER,Hongkong
-0,2012-09-30,ABIN,31673,0,12,75.8658,0,10000719,ADMIN,Shanghai
-0,2012-04-02,FP-GTC,63861,0,5,25.8748,0,10000311,ANALYST,Beijing
-0,2012-03-16,Others,314,0,-99,9.2733,0,10000409,MODELER,Hongkong
-0,2012-09-30,FP-non GTC,60340,0,14,74.6610,0,10000790,MODELER,Hongkong
-0,2012-03-20,Others,87118,0,5,79.3781,0,10000384,MODELER,Hongkong
-0,2012-09-12,FP-GTC,1120,3,5,61.4408,0,10000645,ANALYST,Beijing
-0,2013-12-10,FP-non GTC,20886,0,11,14.8140,0,10000943,ANALYST,Beijing
-0,2012-12-05,FP-GTC,106246,0,12,24.9380,0,10000858,ANALYST,Beijing
-0,2012-08-21,Auction,43479,0,12,22.2008,0,10000310,MODELER,Hongkong
-0,2012-11-30,FP-GTC,175750,0,15,35.1161,0,10000440,ADMIN,Shanghai
-0,2013-10-10,Others,95672,0,11,82.3718,0,10000128,ADMIN,Shanghai
-0,2012-10-17,Auction,80053,0,15,9.8166,0,10000105,ADMIN,Shanghai
-0,2012-03-16,FP-non GTC,57784,0,5,66.2369,0,10000439,MODELER,Hongkong
-0,2012-11-14,ABIN,65,0,11,17.5513,0,10000855,MODELER,Hongkong
-0,2013-06-24,FP-GTC,16509,0,15,53.9195,0,10000130,MODELER,Hongkong
-0,2012-08-13,FP-non GTC,65,0,5,69.8447,0,10000548,MODELER,Hongkong
-0,2012-01-03,Others,38238,0,11,90.3722,0,10000739,ADMIN,Shanghai
-0,2013-11-24,FP-non GTC,175750,3,13,47.3441,0,10000291,ANALYST,Beijing
-0,2013-11-08,Auction,106246,0,5,38.6729,0,10000310,ADMIN,Shanghai
-0,2013-04-07,Others,73506,0,-99,69.8999,0,10000235,ADMIN,Shanghai
-0,2012-10-15,FP-GTC,314,0,13,44.1598,0,10000265,ADMIN,Shanghai
-0,2012-01-20,FP-GTC,80287,0,-99,85.7263,0,10000704,ANALYST,Beijing
-0,2012-08-17,ABIN,32876,0,16,21.2934,0,10000163,ANALYST,Beijing
-0,2013-07-09,Auction,37831,0,15,38.2213,0,10000557,ADMIN,Shanghai
-0,2013-09-21,Others,45333,0,13,25.5384,0,10000184,MODELER,Hongkong
-0,2013-10-28,FP-non GTC,11554,0,16,89.9654,0,10000940,MODELER,Hongkong
-0,2013-04-05,Auction,11554,0,14,41.8676,0,10000384,ANALYST,Beijing
-0,2013-03-25,FP-GTC,43398,0,14,75.0110,0,10000697,ANALYST,Beijing
-0,2012-05-03,ABIN,33038,15,12,64.6735,0,10000147,ADMIN,Shanghai
-0,2012-10-13,ABIN,95672,3,14,3.2128,0,10000547,MODELER,Hongkong
-0,2012-09-11,FP-GTC,37831,0,16,60.3228,0,10000899,MODELER,Hongkong
-0,2012-08-31,Auction,314,0,5,13.2480,0,10000350,ANALYST,Beijing
-0,2012-12-25,Others,165888,0,16,60.3492,0,10000367,ANALYST,Beijing
-0,2012-12-26,FP-non GTC,50677,0,5,58.6078,0,10000523,ADMIN,Shanghai
-0,2012-05-24,FP-GTC,145970,0,5,33.1342,0,10000926,MODELER,Hongkong
-0,2012-06-27,Auction,174106,3,13,55.3039,0,10000430,ANALYST,Beijing
-0,2012-01-02,ABIN,87118,0,14,48.2433,0,10000731,ADMIN,Shanghai
-0,2013-12-14,FP-GTC,50508,0,5,51.5822,0,10000977,ANALYST,Beijing
-0,2012-12-30,Auction,63889,0,12,3.8393,0,10000957,MODELER,Hongkong
-0,2013-10-26,FP-non GTC,24541,0,5,23.6812,0,10000350,ANALYST,Beijing
-0,2013-12-29,ABIN,38238,0,15,99.4389,0,10000605,ANALYST,Beijing
-0,2012-05-26,FP-GTC,100847,0,15,11.0672,0,10000291,ADMIN,Shanghai
-0,2012-12-18,FP-non GTC,164261,0,11,54.9352,0,10000509,ANALYST,Beijing
-0,2013-03-12,ABIN,95672,0,15,85.7152,0,10000742,ADMIN,Shanghai
-0,2013-02-22,ABIN,43398,0,11,65.1970,0,10000294,ADMIN,Shanghai
-0,2012-02-20,Others,175750,0,14,63.2187,0,10000364,MODELER,Hongkong
-0,2013-08-06,Others,32876,0,13,50.8111,0,10000542,MODELER,Hongkong
-0,2013-06-27,Others,13987,0,13,2.3165,0,10000979,ADMIN,Shanghai
-0,2012-07-17,Others,13987,0,16,25.2136,0,10000744,ADMIN,Shanghai
-0,2013-10-12,FP-non GTC,16509,0,5,15.3986,0,10000652,MODELER,Hongkong
-0,2012-12-07,Others,158798,0,5,1.6111,0,10000149,ANALYST,Beijing
-0,2013-02-09,Auction,32876,0,5,37.3237,0,10000467,ADMIN,Shanghai
-0,2012-10-26,Others,44079,0,12,18.1870,0,10000420,ADMIN,Shanghai
-0,2012-04-10,ABIN,132939,0,13,88.5950,0,10000103,MODELER,Hongkong
-0,2013-04-08,FP-non GTC,159184,0,5,92.4421,0,10000933,ADMIN,Shanghai
-0,2012-05-30,Others,80287,0,14,68.1663,0,10000195,ADMIN,Shanghai
-0,2012-02-23,FP-GTC,88750,0,11,19.4075,0,10000038,ADMIN,Shanghai
-0,2013-10-25,ABIN,11554,0,11,27.2512,0,10000228,ANALYST,Beijing
-0,2012-12-02,FP-GTC,41940,0,14,49.5504,0,10000927,ANALYST,Beijing
-0,2013-09-16,FP-GTC,314,0,-99,3.4785,0,10000304,MODELER,Hongkong
-0,2013-11-01,Others,31519,3,15,46.1783,0,10000771,MODELER,Hongkong
-0,2012-10-21,FP-non GTC,31519,0,15,1.7696,0,10000507,MODELER,Hongkong
-0,2013-08-25,Auction,95173,0,13,89.2083,0,10000868,MODELER,Hongkong
-0,2013-11-09,FP-non GTC,150047,3,12,58.2634,0,10000497,ANALYST,Beijing
-0,2012-02-04,FP-GTC,175750,0,11,41.3850,0,10000947,ANALYST,Beijing
-0,2012-10-17,ABIN,26249,0,14,10.5789,0,10000965,ADMIN,Shanghai
-0,2012-03-16,FP-non GTC,963,0,5,17.8949,0,10000908,ANALYST,Beijing
-0,2012-08-06,Others,94847,0,13,96.0332,0,10000595,ANALYST,Beijing
-0,2013-12-23,FP-non GTC,24760,0,16,90.7096,0,10000700,ADMIN,Shanghai
-0,2013-03-29,FP-GTC,9426,3,13,50.9023,0,10000090,ADMIN,Shanghai
-0,2013-03-25,Others,20886,0,-99,35.0414,0,10000171,ANALYST,Beijing
-0,2013-12-10,Auction,95672,0,15,29.8872,0,10000216,MODELER,Hongkong
-0,2012-03-14,Others,12688,0,14,10.4067,0,10000626,MODELER,Hongkong
-0,2013-11-29,FP-non GTC,31519,0,13,89.2334,0,10000199,ANALYST,Beijing
-0,2013-04-29,ABIN,31519,0,-99,99.2460,0,10000565,ADMIN,Shanghai
-0,2012-02-01,FP-GTC,161567,15,11,56.3989,0,10000651,ANALYST,Beijing
-0,2012-03-17,FP-GTC,4943,0,16,0.4422,0,10000829,MODELER,Hongkong
-0,2012-11-06,FP-GTC,156614,0,12,2.3454,0,10000370,ANALYST,Beijing
-0,2012-12-03,Auction,155226,0,13,51.1354,0,10000867,MODELER,Hongkong
-0,2012-09-09,FP-GTC,99985,0,12,9.1236,0,10000281,ANALYST,Beijing
-0,2012-06-16,ABIN,99985,0,16,16.4070,0,10000143,MODELER,Hongkong
-0,2012-05-06,FP-GTC,99985,0,14,6.4304,0,10000514,MODELER,Hongkong
-0,2013-10-20,FP-GTC,36250,0,13,55.6895,0,10000390,ADMIN,Shanghai
-0,2012-10-11,ABIN,106246,0,15,30.6373,0,10000980,ADMIN,Shanghai
-0,2013-08-08,Others,103178,15,12,41.4904,0,10000751,ADMIN,Shanghai
-0,2012-09-05,Auction,314,0,16,3.2615,0,10000280,MODELER,Hongkong
-0,2012-08-07,ABIN,48904,0,13,57.7688,0,10000245,ANALYST,Beijing
-0,2013-07-05,ABIN,314,0,14,28.9444,0,10000888,MODELER,Hongkong
-0,2012-09-10,FP-non GTC,95672,0,-99,54.0914,0,10000601,ANALYST,Beijing
-0,2012-09-18,Auction,25147,0,12,74.4422,0,10000679,ANALYST,Beijing
-0,2012-08-24,FP-non GTC,175750,3,16,45.8282,0,10000397,ANALYST,Beijing
-0,2013-05-29,Others,26249,0,14,12.7681,0,10000967,ANALYST,Beijing
-0,2012-11-17,FP-GTC,94847,0,14,74.4181,0,10000175,ANALYST,Beijing
-0,2012-09-22,ABIN,175750,0,15,85.6879,0,10000453,ADMIN,Shanghai
-0,2013-09-17,ABIN,533,0,11,85.5838,0,10000642,ADMIN,Shanghai
-0,2013-03-28,Others,60340,0,12,72.6495,0,10000397,ADMIN,Shanghai
-0,2013-08-09,Others,216,0,15,88.6918,0,10000867,ADMIN,Shanghai
-0,2013-12-19,Others,43398,0,-99,88.0444,0,10000482,MODELER,Hongkong
-0,2013-12-02,FP-non GTC,15115,0,-99,29.6027,0,10000538,MODELER,Hongkong
-0,2012-11-23,Others,46575,0,5,49.3124,0,10000678,ANALYST,Beijing
-0,2013-06-25,FP-non GTC,16145,0,15,7.4413,0,10000897,MODELER,Hongkong
-0,2012-01-22,FP-GTC,164,0,14,71.8071,0,10000510,ANALYST,Beijing
-0,2013-04-24,FP-GTC,1504,0,12,95.5706,0,10000554,MODELER,Hongkong
-0,2012-03-05,FP-non GTC,12688,0,5,47.7646,0,10000175,ADMIN,Shanghai
-0,2013-02-15,FP-non GTC,16145,0,13,40.9511,0,10000647,MODELER,Hongkong
-0,2013-01-18,Others,36250,0,13,77.3572,0,10000687,ADMIN,Shanghai
-0,2012-06-04,Others,15115,0,15,25.3400,0,10000493,MODELER,Hongkong
-0,2013-10-13,FP-GTC,165888,0,-99,58.1861,0,10000753,ANALYST,Beijing
-0,2012-05-21,Auction,145970,0,5,37.2504,0,10000292,ADMIN,Shanghai
-0,2012-04-26,Auction,11848,0,13,29.2954,0,10000804,MODELER,Hongkong
-0,2013-09-26,FP-GTC,61323,0,13,84.7095,0,10000761,ANALYST,Beijing
-0,2013-03-06,Auction,100847,0,-99,81.7980,0,10000593,ANALYST,Beijing
-0,2012-08-08,ABIN,51582,0,15,15.9790,0,10000138,ADMIN,Shanghai
-0,2012-01-09,Others,1504,0,14,34.0508,0,10000954,ANALYST,Beijing
-0,2013-10-20,ABIN,20886,0,12,36.9353,0,10000408,ADMIN,Shanghai
-0,2013-06-25,Auction,53064,0,11,99.7714,0,10000409,MODELER,Hongkong
-0,2013-05-03,FP-GTC,63861,0,5,39.2974,0,10000668,MODELER,Hongkong
-0,2013-01-26,FP-GTC,100847,0,13,59.5009,0,10000536,ADMIN,Shanghai
-0,2012-09-19,FP-GTC,164261,0,13,15.7583,0,10000231,ANALYST,Beijing
-0,2013-11-16,FP-GTC,164261,0,16,83.6234,0,10000927,ADMIN,Shanghai
-0,2013-05-07,FP-non GTC,20485,0,5,52.9100,0,10000491,MODELER,Hongkong
-0,2013-08-15,Others,32996,15,12,54.7122,0,10000411,MODELER,Hongkong
-0,2013-10-31,FP-GTC,63861,0,14,0.3599,0,10000903,MODELER,Hongkong
-0,2012-06-13,FP-non GTC,159184,0,11,49.9550,0,10000849,ANALYST,Beijing
-0,2012-12-25,Auction,20213,0,-99,11.4752,0,10000583,ANALYST,Beijing
-0,2013-12-15,Auction,759,0,13,33.6991,0,10000390,ADMIN,Shanghai
-0,2012-04-30,Others,87118,0,16,51.4630,0,10000572,MODELER,Hongkong
-0,2012-07-14,Others,10866,0,11,36.9614,0,10000467,ANALYST,Beijing
-0,2013-06-25,FP-non GTC,1357,0,12,17.5618,0,10000426,ANALYST,Beijing
-0,2013-02-06,Auction,13836,0,12,74.3179,0,10000346,ANALYST,Beijing
-0,2012-06-03,ABIN,60340,0,12,82.3722,0,10000531,ANALYST,Beijing
-0,2013-07-23,FP-GTC,139973,0,-99,75.2548,0,10000385,ADMIN,Shanghai
-0,2013-07-06,Others,11554,0,14,40.1129,0,10000724,ADMIN,Shanghai
-0,2013-08-10,FP-non GTC,31519,0,-99,5.2432,0,10000356,ADMIN,Shanghai
-0,2013-07-31,Auction,31673,0,14,51.1089,0,10000598,ADMIN,Shanghai
-0,2013-12-05,Auction,314,0,13,19.9031,0,10000068,ADMIN,Shanghai
-0,2012-12-30,ABIN,50508,0,5,73.8659,0,10000482,MODELER,Hongkong
-0,2012-09-22,Auction,165888,0,12,81.9826,0,10000832,MODELER,Hongkong
-0,2012-07-16,Auction,223,0,5,76.0284,0,10000354,MODELER,Hongkong
-0,2013-01-26,Others,20485,0,12,71.6623,0,10000552,ANALYST,Beijing
-0,2012-11-07,FP-non GTC,57013,0,16,73.2931,0,10000801,ANALYST,Beijing
-0,2012-01-26,FP-non GTC,175750,0,13,18.8970,0,10000649,ADMIN,Shanghai
-0,2012-06-09,FP-non GTC,60340,0,12,11.1614,0,10000830,ADMIN,Shanghai
-0,2012-06-20,Auction,57990,3,5,69.1183,0,10000557,MODELER,Hongkong
-0,2013-01-01,FP-non GTC,45333,0,13,94.0586,0,10000253,ANALYST,Beijing
-0,2013-07-26,FP-non GTC,139973,0,11,39.7239,0,10000441,ADMIN,Shanghai
-0,2012-09-15,FP-GTC,24541,0,15,0.3239,0,10000379,ANALYST,Beijing
-0,2013-09-22,Auction,31519,3,12,80.0315,0,10000436,ANALYST,Beijing
-0,2012-10-27,FP-GTC,223,0,15,39.3790,0,10000420,ANALYST,Beijing
-0,2012-11-20,FP-non GTC,533,0,5,49.4951,0,10000390,ADMIN,Shanghai
-0,2013-12-07,FP-GTC,1349,0,15,93.3008,0,10000398,MODELER,Hongkong
-0,2012-05-30,FP-non GTC,46575,0,12,66.7652,0,10000915,ADMIN,Shanghai
-0,2012-09-07,FP-non GTC,95672,0,14,29.5970,0,10000231,MODELER,Hongkong
-0,2013-04-26,Auction,31673,0,-99,15.8347,0,10000260,ANALYST,Beijing
-0,2012-09-11,FP-non GTC,50508,0,14,80.5444,0,10000263,ADMIN,Shanghai
-0,2013-09-03,FP-non GTC,95173,0,16,33.1487,0,10000493,ADMIN,Shanghai
-0,2012-10-03,FP-non GTC,44079,0,15,99.7408,0,10000828,ADMIN,Shanghai
-0,2012-12-26,ABIN,16145,0,14,40.7826,0,10000062,ANALYST,Beijing
-0,2012-07-17,Auction,26249,0,15,28.6663,0,10000534,ADMIN,Shanghai
-0,2013-06-30,ABIN,63861,0,14,75.6832,0,10000944,ADMIN,Shanghai
-0,2012-01-09,ABIN,156614,0,11,98.4996,0,10000353,ADMIN,Shanghai
-0,2013-09-08,FP-GTC,156614,0,13,12.7473,0,10000063,ADMIN,Shanghai
-0,2013-09-23,Auction,41940,0,5,37.5254,0,10000383,ADMIN,Shanghai
-0,2012-11-11,Auction,145970,0,5,77.1361,0,10000420,MODELER,Hongkong
-0,2013-08-26,Others,11848,0,16,28.2799,0,10000323,MODELER,Hongkong
-0,2012-09-15,Others,11554,0,13,63.7232,0,10000729,ADMIN,Shanghai
-0,2012-01-09,FP-non GTC,25147,0,11,7.3009,0,10000745,ADMIN,Shanghai
-0,2012-08-16,Others,87118,0,15,47.8997,0,10000240,MODELER,Hongkong
-0,2013-12-26,FP-non GTC,16145,0,12,51.0442,0,10000050,MODELER,Hongkong
-0,2012-03-24,ABIN,48027,0,5,26.2083,0,10000600,ANALYST,Beijing
-0,2012-08-22,ABIN,216,0,5,79.9268,0,10000706,ANALYST,Beijing
-0,2013-11-03,FP-GTC,24541,0,12,83.0235,0,10000293,ADMIN,Shanghai
-0,2013-05-18,FP-non GTC,88750,0,-99,84.8856,0,10000147,ADMIN,Shanghai
-0,2013-01-15,ABIN,95672,0,15,86.0386,0,10000590,MODELER,Hongkong
-0,2012-12-03,ABIN,50508,0,11,67.9981,0,10000582,MODELER,Hongkong
-0,2012-06-19,FP-GTC,148324,15,15,53.4811,0,10000793,ANALYST,Beijing
-0,2013-10-06,Auction,6762,0,14,73.5338,0,10000544,MODELER,Hongkong
-0,2013-12-18,ABIN,63861,0,5,50.2892,0,10000769,ADMIN,Shanghai
-0,2013-12-04,Auction,25147,0,5,48.3303,0,10000590,MODELER,Hongkong
-0,2012-04-25,FP-non GTC,62179,0,14,72.3156,0,10000102,ADMIN,Shanghai
-0,2013-11-20,Auction,24760,0,14,91.4883,0,10000370,ADMIN,Shanghai
-0,2013-02-08,Others,20485,0,11,29.1083,0,10000261,MODELER,Hongkong
-0,2013-04-18,Others,2023,0,5,48.4321,0,10000355,ANALYST,Beijing
-0,2012-11-21,Others,32876,0,12,16.7365,0,10000352,ANALYST,Beijing
-0,2012-03-07,FP-GTC,61323,0,-99,32.5836,0,10000494,ADMIN,Shanghai
-0,2012-01-20,FP-non GTC,175750,0,16,52.8153,0,10000025,ADMIN,Shanghai
-0,2013-10-06,FP-GTC,26249,0,-99,1.9539,0,10000660,MODELER,Hongkong
-0,2012-01-10,Auction,57990,0,14,57.5800,0,10000830,ANALYST,Beijing
-0,2013-09-13,Others,46575,0,15,60.3315,0,10000528,MODELER,Hongkong
-0,2012-11-19,FP-non GTC,44079,0,11,73.0457,0,10000482,ANALYST,Beijing
-0,2012-09-23,Auction,95672,0,13,84.6345,0,10000586,MODELER,Hongkong
-0,2013-08-31,Others,216,0,12,34.7429,0,10000676,ANALYST,Beijing
-0,2013-04-11,FP-GTC,963,0,-99,77.7226,0,10000367,ADMIN,Shanghai
-0,2013-03-28,ABIN,15687,0,-99,8.2384,0,10000542,ANALYST,Beijing
-0,2012-05-24,ABIN,152801,0,15,39.0204,0,10000277,ANALYST,Beijing
-0,2013-03-05,ABIN,67698,0,16,40.6091,0,10000886,ADMIN,Shanghai
-0,2013-08-06,Auction,13987,0,13,36.5088,0,10000628,MODELER,Hongkong
-0,2013-02-04,ABIN,20213,0,11,73.5301,0,10000134,MODELER,Hongkong
-0,2012-05-19,FP-non GTC,38238,0,12,59.3237,0,10000500,ADMIN,Shanghai
-0,2013-08-19,ABIN,57990,0,12,10.1688,0,10000715,ANALYST,Beijing
-0,2012-03-28,FP-non GTC,46575,0,16,77.7396,0,10000756,ADMIN,Shanghai
-0,2012-02-19,Auction,43479,0,-99,45.2450,0,10000049,ANALYST,Beijing
-0,2012-04-02,FP-GTC,41940,0,15,58.8415,0,10000195,ADMIN,Shanghai
-0,2013-08-24,Others,16145,0,11,5.4971,0,10000119,MODELER,Hongkong
-0,2013-01-10,Auction,106340,15,12,24.1336,0,10000603,MODELER,Hongkong
-0,2012-09-23,Auction,152801,0,5,70.4024,0,10000384,ANALYST,Beijing
-0,2013-07-29,FP-GTC,73506,0,16,14.5932,0,10000580,ADMIN,Shanghai
-0,2012-02-16,FP-non GTC,67698,0,5,4.4981,0,10000524,MODELER,Hongkong
-0,2013-01-06,Others,65,0,13,64.8343,0,10000731,MODELER,Hongkong
-0,2013-03-02,Auction,43398,0,16,22.6621,0,10000734,ADMIN,Shanghai
-0,2013-10-25,Auction,57990,0,13,64.3384,0,10000961,ADMIN,Shanghai
-0,2012-07-07,FP-GTC,156356,0,16,47.3744,0,10000795,ADMIN,Shanghai
-0,2013-12-19,FP-GTC,67698,0,16,96.9535,0,10000207,MODELER,Hongkong
-0,2013-11-04,Auction,63861,0,5,34.8173,0,10000964,MODELER,Hongkong
-0,2013-01-18,FP-non GTC,174053,3,5,94.6036,0,10000393,ANALYST,Beijing
-0,2013-01-30,Auction,43479,0,16,28.9982,0,10000854,ANALYST,Beijing
-0,2012-05-16,ABIN,24541,0,15,91.6347,0,10000536,MODELER,Hongkong
-0,2013-06-03,FP-non GTC,159184,0,15,27.9722,0,10000644,ADMIN,Shanghai
-0,2013-08-24,FP-GTC,2635,0,14,95.7894,0,10000503,ADMIN,Shanghai
-0,2012-07-02,FP-non GTC,16509,0,5,76.9646,0,10000320,ADMIN,Shanghai
-0,2013-09-09,ABIN,80287,0,16,68.9620,0,10000934,MODELER,Hongkong
-0,2012-04-15,FP-GTC,156356,0,12,95.3640,0,10000269,ANALYST,Beijing
-0,2013-07-10,FP-GTC,1349,0,13,82.7969,0,10000033,MODELER,Hongkong
-0,2012-12-02,FP-GTC,963,0,13,31.4196,0,10000717,ADMIN,Shanghai
-0,2013-02-17,Auction,26249,0,14,9.5202,0,10000543,ANALYST,Beijing
-0,2013-02-17,Others,87118,0,16,77.3899,0,10000647,ADMIN,Shanghai
-0,2012-12-12,Others,6762,0,15,76.3422,0,10000076,ADMIN,Shanghai
-0,2013-07-08,Others,80053,0,5,95.2412,0,10000723,MODELER,Hongkong
-0,2012-08-19,ABIN,32876,0,12,40.9587,0,10000352,ANALYST,Beijing
-0,2013-07-24,Auction,314,0,11,78.8147,0,10000996,ANALYST,Beijing
-0,2013-10-10,Others,57990,0,12,89.8124,0,10000549,ANALYST,Beijing
-0,2013-11-13,Others,139973,0,16,85.5451,0,10000089,ADMIN,Shanghai
-0,2013-03-29,FP-non GTC,25147,0,16,16.2290,0,10000017,MODELER,Hongkong
-0,2012-06-04,FP-non GTC,44079,0,-99,0.1588,0,10000758,MODELER,Hongkong
-0,2012-07-19,FP-non GTC,57784,0,12,84.9441,0,10000553,ANALYST,Beijing
-0,2012-01-08,FP-GTC,155226,0,15,31.9705,0,10000778,ADMIN,Shanghai
-0,2012-09-13,FP-non GTC,963,0,16,39.6392,0,10000799,ADMIN,Shanghai
-0,2012-12-24,Others,175750,0,15,77.3617,0,10000164,MODELER,Hongkong
-0,2013-08-31,Auction,57990,0,12,76.7885,0,10000580,ANALYST,Beijing
-0,2013-08-06,FP-non GTC,156356,0,13,86.0218,0,10000445,ANALYST,Beijing
-0,2013-05-29,FP-non GTC,11848,0,11,23.0269,0,10000372,MODELER,Hongkong
-0,2013-05-19,Others,53064,0,13,66.3990,0,10000390,MODELER,Hongkong
-0,2012-11-01,FP-non GTC,51582,0,14,57.6157,0,10000061,ADMIN,Shanghai
-0,2013-01-01,Auction,1357,0,-99,18.2117,0,10000860,ANALYST,Beijing
-0,2013-05-17,Others,121153,0,14,79.4534,0,10000155,MODELER,Hongkong
-0,2013-07-04,FP-GTC,80053,0,5,43.3271,0,10000456,ANALYST,Beijing
-0,2013-12-17,Others,165888,0,-99,9.8402,0,10000357,MODELER,Hongkong
-0,2013-11-28,FP-GTC,26262,0,-99,1.4013,0,10000731,ADMIN,Shanghai
-0,2013-02-08,FP-GTC,65,0,11,61.9604,0,10000176,ADMIN,Shanghai
-0,2012-05-17,ABIN,9426,3,12,68.0170,0,10000895,ANALYST,Beijing
-0,2012-08-29,Auction,159184,0,13,43.7406,0,10000723,MODELER,Hongkong
-0,2013-10-06,FP-GTC,61323,0,14,85.9325,0,10000692,ANALYST,Beijing
-0,2013-08-08,FP-GTC,20886,0,14,88.0137,0,10000063,ADMIN,Shanghai
-0,2013-04-06,FP-non GTC,156356,0,16,67.1201,0,10000441,ADMIN,Shanghai
-0,2012-03-09,Auction,1504,0,13,45.8878,0,10000862,ANALYST,Beijing
-0,2013-12-13,FP-GTC,139973,3,16,58.7879,0,10000947,ADMIN,Shanghai
-0,2013-02-03,ABIN,95173,0,-99,33.2714,0,10000634,ANALYST,Beijing
-0,2013-02-19,Others,41940,0,5,32.2179,0,10000257,ANALYST,Beijing
-0,2012-05-09,ABIN,65,0,11,96.0579,0,10000675,ANALYST,Beijing
-0,2012-10-30,Auction,80135,0,11,55.5335,0,10000288,ANALYST,Beijing
-0,2013-07-14,ABIN,11554,0,16,9.7012,0,10000210,MODELER,Hongkong
-0,2012-07-29,Others,11554,0,5,91.5938,0,10000736,ANALYST,Beijing
-0,2012-06-03,ABIN,80287,0,13,99.7431,0,10000403,ADMIN,Shanghai
-0,2012-10-10,Auction,36250,0,13,14.7056,0,10000561,ANALYST,Beijing
-0,2013-06-20,ABIN,20485,0,5,23.9120,0,10000798,ANALYST,Beijing
-0,2013-12-26,Others,11554,0,15,27.2028,0,10000154,MODELER,Hongkong
-0,2013-05-07,Auction,11848,0,-99,73.7354,0,10000448,MODELER,Hongkong
-0,2013-12-14,ABIN,61323,0,16,44.6086,0,10000555,ADMIN,Shanghai
-0,2012-08-29,FP-GTC,139973,0,14,34.7404,0,10000686,ANALYST,Beijing
-0,2013-12-31,FP-GTC,100847,0,15,70.6027,0,10000534,MODELER,Hongkong
-0,2013-12-13,FP-non GTC,16145,3,12,76.5802,0,10000864,ADMIN,Shanghai
-0,2012-01-24,FP-non GTC,57990,0,-99,54.7904,0,10000325,ADMIN,Shanghai
-0,2013-07-26,Others,20485,0,11,9.3130,0,10000991,MODELER,Hongkong
-0,2013-09-30,ABIN,31519,0,15,95.7797,0,10000701,ADMIN,Shanghai
-0,2012-03-30,FP-non GTC,88750,0,16,34.6777,0,10000494,ANALYST,Beijing
-0,2012-05-11,Others,20485,0,16,2.2782,0,10000436,MODELER,Hongkong
-0,2012-11-21,FP-non GTC,156356,0,13,3.4276,0,10000574,MODELER,Hongkong
-0,2012-11-19,FP-non GTC,36250,0,16,42.1665,0,10000885,ADMIN,Shanghai
-0,2013-01-07,Others,20485,0,13,29.1424,0,10000931,ANALYST,Beijing
-0,2013-01-16,ABIN,88750,0,13,87.3858,0,10000276,ADMIN,Shanghai
-0,2012-07-20,ABIN,25147,0,-99,41.9809,0,10000928,ADMIN,Shanghai
-0,2013-06-27,FP-non GTC,75665,0,11,65.3889,0,10000587,ADMIN,Shanghai
-0,2013-12-04,FP-non GTC,45333,0,15,41.7577,0,10000979,ADMIN,Shanghai
-0,2012-05-01,Auction,4943,0,11,76.3978,0,10000385,ANALYST,Beijing
-0,2013-05-03,Others,66767,15,-99,69.0620,0,10000186,ANALYST,Beijing
-0,2013-02-14,FP-non GTC,95672,0,14,15.6152,0,10000356,ANALYST,Beijing
-0,2012-01-01,Others,1357,0,13,16.7271,0,10000263,ANALYST,Beijing
-0,2012-01-05,FP-non GTC,67703,3,5,32.2005,0,10000141,ADMIN,Shanghai
-0,2013-12-15,Others,2023,0,-99,55.3349,0,10000920,ADMIN,Shanghai
-0,2012-10-02,FP-GTC,314,0,14,95.9217,0,10000647,ANALYST,Beijing
-0,2012-10-27,Others,64076,0,5,3.4266,0,10000486,ADMIN,Shanghai
-0,2013-10-17,Others,41940,0,15,3.0363,0,10000299,ADMIN,Shanghai
-0,2013-02-09,Others,13836,0,15,37.1746,0,10000799,MODELER,Hongkong
-0,2013-04-03,FP-GTC,31519,0,15,83.3031,0,10000656,ADMIN,Shanghai
-0,2013-08-30,Others,63861,0,13,37.8620,0,10000958,ADMIN,Shanghai
-0,2012-01-01,Others,1349,0,13,0.7227,0,10000774,ADMIN,Shanghai
-0,2013-03-24,FP-non GTC,87118,0,13,32.5615,0,10000661,ADMIN,Shanghai
-0,2012-12-03,FP-non GTC,216,0,5,40.1447,0,10000923,ANALYST,Beijing
-0,2012-07-12,FP-GTC,94847,0,5,74.4586,0,10000161,MODELER,Hongkong
-0,2013-03-18,Others,1161,3,-99,70.1521,0,10000123,ANALYST,Beijing
-0,2013-11-17,Auction,165888,0,5,16.1344,0,10000029,ANALYST,Beijing
-0,2013-11-25,FP-non GTC,44079,0,5,18.0996,0,10000461,MODELER,Hongkong
-0,2012-12-06,FP-GTC,159184,0,15,63.6868,0,10000399,ANALYST,Beijing
-0,2013-09-27,FP-non GTC,161567,15,15,35.8966,0,10000283,MODELER,Hongkong
-0,2013-11-02,ABIN,20865,0,5,70.2863,0,10000724,ADMIN,Shanghai
-0,2013-04-29,Auction,314,0,13,53.6862,0,10000676,MODELER,Hongkong
-0,2013-01-21,Auction,20886,0,-99,32.5548,0,10000052,MODELER,Hongkong
-0,2012-04-18,FP-GTC,67698,0,14,90.8206,0,10000221,ANALYST,Beijing
-0,2013-10-14,Others,46575,0,13,92.8392,0,10000187,ANALYST,Beijing
-0,2013-07-06,FP-GTC,26249,0,-99,54.6729,0,10000651,MODELER,Hongkong
-0,2012-09-15,Others,16145,0,15,70.0461,0,10000279,ADMIN,Shanghai
-0,2013-11-02,Others,38238,0,11,22.9595,0,10000451,MODELER,Hongkong
-0,2012-06-03,ABIN,57013,0,11,28.9005,0,10000028,ADMIN,Shanghai
-0,2013-10-08,FP-GTC,20886,0,14,24.6958,0,10000676,ANALYST,Beijing
-0,2013-04-11,Auction,100847,0,14,42.1878,0,10000645,MODELER,Hongkong
-0,2013-11-07,Auction,45333,0,13,58.1089,0,10000182,ANALYST,Beijing
-0,2012-10-18,FP-non GTC,57990,0,15,37.9049,0,10000696,ADMIN,Shanghai
-0,2012-11-28,FP-non GTC,63889,0,5,59.1268,0,10000116,ADMIN,Shanghai
-0,2012-03-02,Auction,45333,0,13,37.4799,0,10000298,ANALYST,Beijing
-0,2013-07-27,FP-non GTC,75665,0,12,19.4230,0,10000333,ADMIN,Shanghai
-0,2012-12-01,Auction,44079,0,11,95.4596,0,10000163,ANALYST,Beijing
-0,2012-04-11,FP-non GTC,161567,15,13,47.4582,0,10000082,ADMIN,Shanghai
-0,2013-06-23,ABIN,175750,3,13,23.9511,0,10000560,ANALYST,Beijing
-0,2012-02-17,Others,46575,0,15,25.7613,0,10000308,ADMIN,Shanghai
-0,2013-05-19,ABIN,223,0,15,64.7127,0,10000850,ANALYST,Beijing
-0,2012-10-29,FP-non GTC,159184,0,5,15.4188,0,10000995,ADMIN,Shanghai
-0,2012-07-17,Auction,4943,0,11,32.1734,0,10000820,ANALYST,Beijing
-0,2013-01-03,ABIN,57784,0,5,47.7542,0,10000563,MODELER,Hongkong
-0,2013-07-17,FP-GTC,150047,3,16,35.0905,0,10000545,ADMIN,Shanghai
-0,2013-07-20,Others,87118,0,14,24.6574,0,10000985,MODELER,Hongkong
-0,2013-12-14,Others,11848,0,14,80.9504,0,10000318,MODELER,Hongkong
-0,2013-01-16,Auction,106246,0,12,94.2201,0,10000113,ADMIN,Shanghai
-0,2012-11-04,Others,63861,0,12,71.8354,0,10000985,MODELER,Hongkong
-0,2012-08-25,FP-non GTC,100847,0,5,68.7418,0,10000581,ADMIN,Shanghai
-0,2013-07-22,Auction,156356,0,15,63.6314,0,10000140,ANALYST,Beijing
-0,2013-11-04,Auction,67698,0,16,15.6061,0,10000128,MODELER,Hongkong
-0,2013-03-01,FP-GTC,20485,0,-99,49.2253,0,10000722,MODELER,Hongkong
-0,2013-12-03,FP-GTC,46575,0,-99,71.5261,0,10000796,ADMIN,Shanghai
-0,2013-03-25,FP-non GTC,60340,0,11,23.0796,0,10000605,ADMIN,Shanghai
-0,2012-11-16,FP-non GTC,99985,0,11,91.6223,0,10000619,ANALYST,Beijing
-0,2012-05-24,Auction,16509,0,16,97.7044,0,10000002,ADMIN,Shanghai
-0,2012-04-04,ABIN,139973,3,13,16.7393,0,10000923,MODELER,Hongkong
-0,2012-07-20,FP-GTC,174106,3,13,8.8874,0,10000134,MODELER,Hongkong
-0,2013-09-12,Auction,33038,15,13,46.7475,0,10000154,MODELER,Hongkong
-0,2012-06-12,ABIN,57990,0,11,33.1479,0,10000036,ADMIN,Shanghai
-0,2013-08-31,ABIN,46575,0,12,41.0635,0,10000310,ADMIN,Shanghai
-0,2012-12-18,Auction,1349,0,5,14.6328,0,10000296,MODELER,Hongkong
-0,2012-02-18,ABIN,16509,0,-99,76.3163,0,10000486,MODELER,Hongkong
-0,2013-07-02,Auction,3838,0,11,95.7402,0,10000963,ANALYST,Beijing
-0,2012-06-28,Auction,145970,0,16,41.1425,0,10000646,ADMIN,Shanghai
-0,2013-11-03,FP-GTC,12688,0,5,73.9106,0,10000357,MODELER,Hongkong
-0,2012-03-30,FP-non GTC,16509,0,5,39.5703,0,10000495,MODELER,Hongkong
-0,2012-08-18,FP-non GTC,75665,0,11,61.4928,0,10000522,MODELER,Hongkong
-0,2013-07-29,Others,156356,0,16,98.2405,0,10000417,ANALYST,Beijing
-0,2013-07-19,Others,32876,0,12,68.5148,0,10000306,ANALYST,Beijing
-0,2012-02-13,ABIN,175750,0,16,64.5444,0,10000274,ANALYST,Beijing
-0,2013-02-04,FP-non GTC,13836,0,-99,65.7663,0,10000511,ADMIN,Shanghai
-0,2013-07-24,FP-GTC,165888,0,16,91.7808,0,10000330,ADMIN,Shanghai
-0,2012-04-25,Others,41940,0,-99,6.5053,0,10000357,MODELER,Hongkong
-0,2013-11-28,ABIN,106340,15,12,71.4264,0,10000155,ANALYST,Beijing
-0,2012-09-16,FP-non GTC,170083,3,-99,80.2442,0,10000690,ANALYST,Beijing
-0,2012-05-10,FP-GTC,16145,0,14,11.0775,0,10000372,ANALYST,Beijing
-0,2013-10-28,FP-non GTC,15687,0,16,65.9436,0,10000032,ANALYST,Beijing
-0,2013-05-17,FP-non GTC,94847,0,13,37.3520,0,10000044,ADMIN,Shanghai
-0,2013-05-31,FP-GTC,223,0,5,93.3181,0,10000365,MODELER,Hongkong
-0,2012-01-07,FP-non GTC,73506,0,13,13.1225,0,10000218,ANALYST,Beijing
-0,2013-07-01,FP-GTC,64076,0,15,78.1094,0,10000081,ADMIN,Shanghai
-0,2013-07-26,Others,67698,0,11,14.9245,0,10000775,ANALYST,Beijing
-0,2013-03-02,Auction,75665,0,5,84.2445,0,10000162,ANALYST,Beijing
-0,2012-01-13,FP-GTC,1120,3,16,43.8855,0,10000157,MODELER,Hongkong
-0,2012-06-02,ABIN,53064,0,12,17.3600,0,10000091,ADMIN,Shanghai
-0,2012-02-23,ABIN,31387,3,14,43.1757,0,10000071,ADMIN,Shanghai
-0,2013-10-22,FP-non GTC,158798,0,15,10.9759,0,10000341,MODELER,Hongkong
-0,2013-05-23,FP-GTC,11848,0,-99,7.5230,0,10000277,MODELER,Hongkong
-0,2013-07-25,FP-GTC,43479,0,14,13.2620,0,10000500,MODELER,Hongkong
-0,2012-03-03,FP-non GTC,11848,0,14,95.0683,0,10000164,ADMIN,Shanghai
-0,2012-01-09,ABIN,11554,0,15,6.8777,0,10000785,ANALYST,Beijing
-0,2013-05-08,ABIN,80287,0,14,95.5320,0,10000595,ANALYST,Beijing
-0,2013-07-26,FP-GTC,121153,0,12,28.7213,0,10000829,MODELER,Hongkong
-0,2012-11-27,FP-GTC,31673,0,14,7.8033,0,10000498,ANALYST,Beijing
-0,2013-06-04,ABIN,43398,0,15,76.0187,0,10000061,ANALYST,Beijing
-0,2012-10-05,ABIN,15687,0,13,87.1235,0,10000649,MODELER,Hongkong
-0,2013-06-29,Auction,61323,0,14,78.4000,0,10000765,ANALYST,Beijing
-0,2012-07-25,ABIN,216,0,12,43.1556,0,10000597,ANALYST,Beijing
-0,2013-01-03,FP-non GTC,121153,0,12,70.1009,0,10000201,MODELER,Hongkong
-0,2013-10-22,FP-non GTC,170302,15,12,92.5959,0,10000151,MODELER,Hongkong
-0,2012-02-03,FP-non GTC,155226,0,12,68.6486,0,10000870,MODELER,Hongkong
-0,2013-03-30,FP-GTC,139973,0,11,93.3324,0,10000585,ANALYST,Beijing
-0,2012-11-21,Others,20865,0,11,68.0525,0,10000115,ADMIN,Shanghai
-0,2012-11-09,ABIN,11848,0,13,66.3745,0,10000652,ADMIN,Shanghai
-0,2012-10-22,Auction,2023,0,13,52.4918,0,10000836,ANALYST,Beijing
-0,2013-01-07,Auction,164261,0,-99,56.4680,0,10000560,ANALYST,Beijing
-0,2012-01-05,Others,80053,0,-99,34.1305,0,10000905,ADMIN,Shanghai
-0,2012-08-27,FP-GTC,64076,0,14,3.0691,0,10000389,ADMIN,Shanghai
-0,2013-06-23,Others,139973,0,16,89.7673,0,10000636,ANALYST,Beijing
-0,2013-09-13,Auction,67698,0,15,62.9192,0,10000596,MODELER,Hongkong
-0,2012-08-18,FP-GTC,43398,0,12,45.3384,0,10000382,ADMIN,Shanghai
-0,2012-10-27,FP-non GTC,1120,3,5,84.6466,0,10000487,ANALYST,Beijing
-0,2012-05-24,Auction,24541,0,14,56.7041,0,10000366,ADMIN,Shanghai
-0,2013-02-12,Auction,64076,0,13,1.1360,0,10000089,ADMIN,Shanghai
-0,2012-02-19,FP-non GTC,43398,0,14,7.2416,0,10000129,ANALYST,Beijing
-0,2012-07-30,ABIN,48027,0,11,41.6704,0,10000761,MODELER,Hongkong
-0,2013-10-04,FP-non GTC,37831,0,16,31.9567,0,10000610,MODELER,Hongkong
-0,2013-11-18,Auction,223,0,16,21.8155,0,10000079,ANALYST,Beijing
-0,2012-06-08,Others,80135,0,16,90.0166,0,10000478,MODELER,Hongkong
-0,2012-10-25,Others,159184,0,16,92.0436,0,10000166,ANALYST,Beijing
-0,2013-10-22,ABIN,13987,0,15,62.5546,0,10000592,ADMIN,Shanghai
-0,2013-11-01,ABIN,103324,15,16,14.9475,0,10000924,ADMIN,Shanghai
-0,2013-03-21,FP-GTC,1120,3,-99,29.5252,0,10000758,ADMIN,Shanghai
-0,2012-03-13,Others,759,0,16,62.4158,0,10000810,MODELER,Hongkong
-0,2012-05-14,Auction,95672,0,16,92.0781,0,10000609,ANALYST,Beijing
-0,2013-09-28,FP-GTC,64076,0,12,37.3599,0,10000487,ADMIN,Shanghai
-0,2013-10-09,ABIN,60606,3,13,48.9467,0,10000007,ANALYST,Beijing
-0,2013-04-21,ABIN,26249,0,14,67.1520,0,10000257,MODELER,Hongkong
-0,2013-05-08,FP-GTC,20886,0,13,19.5685,0,10000122,ANALYST,Beijing
-0,2013-12-29,ABIN,1357,0,12,89.9069,0,10000900,MODELER,Hongkong
-0,2013-02-14,FP-GTC,63889,0,16,74.5657,0,10000676,ANALYST,Beijing
-0,2012-02-25,Auction,88750,0,-99,92.3939,0,10000769,MODELER,Hongkong
-0,2012-06-22,Others,13836,0,14,77.1277,0,10000795,MODELER,Hongkong
-0,2012-01-30,FP-GTC,43479,0,15,48.2346,0,10000013,ANALYST,Beijing
-0,2013-08-17,ABIN,57990,3,-99,87.0638,0,10000277,ADMIN,Shanghai
-0,2013-06-24,FP-GTC,1357,0,15,75.0985,0,10000056,ANALYST,Beijing
-0,2013-04-08,ABIN,57013,0,11,21.4485,0,10000195,ANALYST,Beijing
-0,2012-04-07,FP-non GTC,24541,0,-99,40.6197,0,10000313,ANALYST,Beijing
-0,2012-07-26,Others,963,0,16,99.8137,0,10000257,ANALYST,Beijing
-0,2012-07-18,Others,15115,0,-99,9.9153,0,10000937,MODELER,Hongkong
-0,2012-01-04,Auction,63889,0,13,84.5004,0,10000467,MODELER,Hongkong
-0,2013-05-25,Auction,1120,3,14,40.3618,0,10000076,MODELER,Hongkong
-0,2013-03-30,FP-GTC,38238,0,12,94.9870,0,10000997,ANALYST,Beijing
-0,2012-05-12,Auction,32876,0,-99,38.5800,0,10000943,ANALYST,Beijing
-0,2012-11-21,FP-GTC,100847,0,14,7.7495,0,10000588,MODELER,Hongkong
-0,2013-10-02,Auction,15868,0,5,92.2309,0,10000520,ADMIN,Shanghai
-0,2013-11-05,ABIN,31673,0,-99,75.9838,0,10000344,ANALYST,Beijing
-0,2013-03-23,FP-non GTC,48904,0,-99,15.4260,0,10000090,MODELER,Hongkong
-0,2012-12-27,FP-non GTC,43479,0,5,35.7689,0,10000066,ANALYST,Beijing
-0,2013-01-11,FP-non GTC,223,0,12,5.9423,0,10000174,ANALYST,Beijing
-0,2012-05-25,Auction,50508,0,16,81.5853,0,10000337,MODELER,Hongkong
-0,2012-09-08,Others,6762,0,15,11.8473,0,10000718,ANALYST,Beijing
-0,2013-07-08,Auction,139973,0,5,11.7025,0,10000537,ANALYST,Beijing
-0,2013-04-23,ABIN,32876,0,12,40.4116,0,10000798,ADMIN,Shanghai
-0,2013-03-22,Auction,2023,0,15,89.8093,0,10000662,ANALYST,Beijing
-0,2012-11-01,Others,75708,3,11,95.9527,0,10000776,MODELER,Hongkong
-0,2012-01-29,ABIN,156356,0,16,64.6181,0,10000910,ADMIN,Shanghai
-0,2012-01-20,Others,2635,0,11,81.6196,0,10000893,ANALYST,Beijing
-0,2012-05-27,FP-non GTC,94847,0,15,87.1713,0,10000121,ANALYST,Beijing
-0,2013-12-17,Others,156614,0,14,87.7791,0,10000531,MODELER,Hongkong
-0,2013-03-05,ABIN,80135,0,16,64.8966,0,10000452,MODELER,Hongkong
-0,2013-01-26,ABIN,156356,0,16,59.0108,0,10000671,ADMIN,Shanghai
-0,2012-01-08,FP-non GTC,57990,0,15,56.3470,0,10000028,ADMIN,Shanghai
-0,2013-08-04,ABIN,13836,0,11,98.5679,0,10000481,ADMIN,Shanghai
-0,2013-04-04,Others,63861,0,13,14.3911,0,10000944,ANALYST,Beijing
-0,2013-02-15,FP-GTC,2023,0,5,5.5878,0,10000816,MODELER,Hongkong
-0,2013-05-05,FP-non GTC,175750,0,-99,80.9471,0,10000727,MODELER,Hongkong
-0,2013-06-24,FP-GTC,38238,0,12,96.7825,0,10000202,ANALYST,Beijing
-0,2013-11-04,ABIN,45333,0,14,57.9540,0,10000767,ANALYST,Beijing
-0,2012-02-23,FP-non GTC,57990,0,5,16.4790,0,10000146,ADMIN,Shanghai
-0,2013-01-13,ABIN,158798,0,11,45.5371,0,10000133,ANALYST,Beijing
-0,2013-11-16,ABIN,73506,0,16,35.7207,0,10000304,ANALYST,Beijing
-0,2012-11-15,Auction,64076,0,15,66.0059,0,10000375,ANALYST,Beijing
-0,2012-01-03,ABIN,156614,0,15,84.8759,0,10000095,ADMIN,Shanghai
-0,2012-09-22,Auction,57990,0,14,42.7313,0,10000953,MODELER,Hongkong
-0,2013-11-03,FP-non GTC,67698,0,11,8.9322,0,10000913,MODELER,Hongkong
-0,2012-08-31,ABIN,1504,0,5,34.3706,0,10000748,ANALYST,Beijing
-0,2013-12-13,FP-GTC,15868,0,-99,18.3204,0,10000495,MODELER,Hongkong
-0,2012-07-20,ABIN,533,0,11,24.9451,0,10000237,MODELER,Hongkong
-0,2012-07-14,ABIN,41940,0,11,42.9796,0,10000328,ANALYST,Beijing
-0,2013-11-06,Others,32876,0,15,4.2693,0,10000383,ADMIN,Shanghai
-0,2012-07-02,Auction,41940,0,12,19.2987,0,10000196,ADMIN,Shanghai
-0,2012-06-21,FP-GTC,20865,0,-99,36.5029,0,10000098,ANALYST,Beijing
-0,2012-09-19,ABIN,159184,0,15,65.9768,0,10000517,ANALYST,Beijing
-0,2012-02-11,Others,16145,0,14,41.4762,0,10000733,ANALYST,Beijing
-0,2012-07-19,Auction,63861,0,11,30.7294,0,10000351,ANALYST,Beijing
-0,2013-05-24,ABIN,1349,0,12,61.0346,0,10000078,MODELER,Hongkong
-0,2013-06-26,Auction,139973,3,11,49.3849,0,10000537,ADMIN,Shanghai
-0,2013-11-30,Others,1357,0,16,62.0388,0,10000532,MODELER,Hongkong
-0,2012-11-01,Others,121153,0,5,64.8814,0,10000820,ANALYST,Beijing
-0,2013-10-20,Auction,20485,0,5,88.9093,0,10000467,MODELER,Hongkong
-0,2013-04-15,FP-GTC,43479,0,13,72.5969,0,10000352,MODELER,Hongkong
-0,2012-04-02,FP-GTC,33977,15,16,42.1845,0,10000614,ANALYST,Beijing
-0,2012-03-20,ABIN,2023,0,16,95.0254,0,10000014,ADMIN,Shanghai
-0,2013-02-21,FP-non GTC,57990,0,5,25.0404,0,10000386,ANALYST,Beijing
-0,2013-06-02,FP-non GTC,6762,0,12,60.3684,0,10000783,ADMIN,Shanghai
-0,2012-01-07,FP-GTC,759,0,11,80.1720,0,10000952,MODELER,Hongkong
-0,2012-12-01,FP-non GTC,533,0,12,47.1653,0,10000550,ADMIN,Shanghai
-0,2012-11-03,ABIN,99985,0,16,40.8280,0,10000629,MODELER,Hongkong
-0,2013-10-15,FP-GTC,64076,0,15,55.9541,0,10000531,ANALYST,Beijing
-0,2013-12-30,Auction,80135,0,13,13.2503,0,10000425,ADMIN,Shanghai
-0,2012-06-28,FP-GTC,15868,0,12,76.8360,0,10000557,MODELER,Hongkong
-0,2013-04-07,FP-GTC,10866,0,16,37.7540,0,10000810,ADMIN,Shanghai
-0,2013-08-03,FP-GTC,139255,15,13,70.8704,0,10000514,MODELER,Hongkong
-0,2012-07-23,ABIN,121153,0,5,65.6362,0,10000166,MODELER,Hongkong
-0,2013-05-04,FP-GTC,31519,0,5,38.9751,0,10000932,ANALYST,Beijing
-0,2013-01-27,ABIN,175750,3,-99,81.7736,0,10000529,ADMIN,Shanghai
-0,2013-03-30,ABIN,11554,0,15,37.8703,0,10000509,MODELER,Hongkong
-0,2012-06-03,FP-GTC,20485,0,-99,62.4729,0,10000404,MODELER,Hongkong
-0,2012-05-09,FP-non GTC,63861,0,11,35.1334,0,10000175,ADMIN,Shanghai
-0,2013-12-25,FP-non GTC,6762,0,12,95.0363,0,10000101,ANALYST,Beijing
-0,2012-11-18,FP-GTC,175750,0,5,95.8938,0,10000537,ADMIN,Shanghai
-0,2013-01-07,FP-non GTC,57784,0,14,0.2995,0,10000847,ADMIN,Shanghai
-0,2012-03-11,Auction,63861,0,12,58.1028,0,10000912,ANALYST,Beijing
-0,2012-03-23,Others,80287,0,14,24.7900,0,10000967,ADMIN,Shanghai
-0,2012-03-19,ABIN,99985,0,16,5.9564,0,10000684,ADMIN,Shanghai
-0,2013-11-24,Auction,20886,0,15,28.1384,0,10000239,ADMIN,Shanghai
-0,2012-04-04,FP-GTC,100847,0,11,91.4446,0,10000743,ADMIN,Shanghai
-0,2013-12-15,ABIN,44079,0,16,39.6860,0,10000476,MODELER,Hongkong
-0,2013-10-06,FP-GTC,132939,0,12,20.8855,0,10000854,ADMIN,Shanghai
-0,2013-12-07,Others,25147,0,14,16.4357,0,10000198,ADMIN,Shanghai
-0,2012-02-04,Others,158798,0,13,44.5451,0,10000543,MODELER,Hongkong
-0,2013-11-07,FP-GTC,10866,0,16,8.5249,0,10000105,ADMIN,Shanghai
-0,2012-08-04,FP-GTC,2635,0,12,11.7572,0,10000382,ADMIN,Shanghai
-0,2012-08-14,Auction,152801,0,15,46.6818,0,10000205,ADMIN,Shanghai
-0,2013-02-25,Auction,50508,0,15,37.8443,0,10000644,MODELER,Hongkong
-0,2013-10-09,ABIN,223,0,13,58.8049,0,10000768,ANALYST,Beijing
-0,2012-01-10,Auction,20485,0,11,92.2997,0,10000975,ADMIN,Shanghai
-0,2013-05-03,FP-non GTC,37831,0,12,15.9399,0,10000280,MODELER,Hongkong
-0,2013-11-12,ABIN,73506,0,12,13.9272,0,10000332,ANALYST,Beijing
-0,2013-08-16,Others,164,0,12,39.2371,0,10000887,MODELER,Hongkong
-0,2013-10-27,FP-non GTC,15868,0,16,51.4769,0,10000303,MODELER,Hongkong
-0,2013-04-27,FP-non GTC,80287,0,15,90.8971,0,10000207,MODELER,Hongkong
-0,2013-11-06,FP-non GTC,11554,0,12,26.0123,0,10000855,ADMIN,Shanghai
-0,2013-11-25,Others,6762,0,14,96.0198,0,10000418,ANALYST,Beijing
-0,2012-08-09,ABIN,80135,0,15,89.0544,0,10000861,MODELER,Hongkong
-0,2013-09-28,ABIN,16509,0,12,90.2997,0,10000520,MODELER,Hongkong
-0,2012-03-19,FP-GTC,43479,0,-99,93.8319,0,10000045,MODELER,Hongkong
-0,2012-05-25,FP-GTC,139973,0,16,8.9816,0,10000684,ADMIN,Shanghai
-0,2013-04-04,Auction,25147,0,11,43.4557,0,10000801,MODELER,Hongkong
-0,2013-07-07,Auction,67698,0,14,59.3634,0,10000305,ADMIN,Shanghai
-0,2013-10-27,ABIN,63861,0,14,48.1526,0,10000963,MODELER,Hongkong
-0,2012-05-31,Auction,130,0,5,1.0560,0,10000357,MODELER,Hongkong
-0,2012-08-21,Auction,13836,0,16,14.4247,0,10000278,ADMIN,Shanghai
-0,2013-07-24,Auction,15568,15,14,14.5748,0,10000590,ADMIN,Shanghai
-0,2013-04-05,ABIN,12688,0,12,2.0636,0,10000951,ADMIN,Shanghai
-0,2013-02-27,FP-non GTC,73506,0,14,2.7139,0,10000134,ADMIN,Shanghai
-0,2013-06-16,FP-non GTC,164,0,5,59.4198,0,10000745,ANALYST,Beijing
-0,2012-04-01,Others,20213,0,11,77.8490,0,10000929,ANALYST,Beijing
-0,2013-12-02,FP-non GTC,155226,0,16,71.1100,0,10000433,ADMIN,Shanghai
-0,2013-06-07,Auction,158798,0,15,98.6517,0,10000320,ADMIN,Shanghai
-0,2012-11-25,ABIN,31519,0,12,68.8974,0,10000726,ADMIN,Shanghai
-0,2013-04-17,FP-GTC,57013,0,14,49.4405,0,10000050,ADMIN,Shanghai
-0,2013-03-18,FP-non GTC,175750,0,13,2.3784,0,10000559,ANALYST,Beijing
-0,2013-08-13,Others,62179,0,11,36.4940,0,10000652,MODELER,Hongkong
-0,2012-10-15,ABIN,175750,0,14,42.7269,0,10000560,MODELER,Hongkong
-0,2012-01-08,Others,6762,0,5,58.5212,0,10000829,ADMIN,Shanghai
-0,2013-05-20,FP-non GTC,216,0,14,16.9644,0,10000104,ADMIN,Shanghai
-0,2012-12-07,Others,51582,0,5,6.0617,0,10000228,ANALYST,Beijing
-0,2013-12-04,ABIN,57013,0,16,48.2921,0,10000347,MODELER,Hongkong
-0,2013-12-17,ABIN,759,0,14,12.8117,0,10000161,ANALYST,Beijing
-0,2012-02-08,FP-non GTC,24760,0,13,11.3190,0,10000938,MODELER,Hongkong
-0,2013-01-03,FP-non GTC,15568,15,14,0.3508,0,10000964,ADMIN,Shanghai
-0,2013-04-21,Others,87118,0,12,9.5385,0,10000949,ADMIN,Shanghai
-0,2013-11-13,Others,36250,0,12,0.9029,0,10000532,ANALYST,Beijing
-0,2013-03-18,FP-GTC,164,0,12,3.7727,0,10000237,ADMIN,Shanghai
-0,2013-06-29,Others,15868,0,11,23.3421,0,10000671,MODELER,Hongkong
-0,2013-12-25,Others,25147,0,5,99.4168,0,10000708,ANALYST,Beijing
-0,2012-10-06,FP-GTC,533,0,12,40.5069,0,10000295,MODELER,Hongkong
-0,2013-02-21,ABIN,216,0,14,84.3818,0,10000637,ADMIN,Shanghai
-0,2012-08-27,FP-non GTC,67698,0,16,7.0299,0,10000671,MODELER,Hongkong
-0,2013-04-13,Others,51582,0,13,67.9730,0,10000778,ANALYST,Beijing
-0,2013-07-10,FP-GTC,139973,0,13,24.8423,0,10000253,ADMIN,Shanghai
-0,2013-11-02,ABIN,1349,0,14,56.6310,0,10000922,ANALYST,Beijing
-0,2013-05-11,Others,26249,0,16,49.7279,0,10000610,ANALYST,Beijing
-0,2013-01-17,FP-non GTC,118687,3,11,34.6913,0,10000002,MODELER,Hongkong
-0,2012-07-02,Others,148324,15,-99,90.6687,0,10000613,ANALYST,Beijing
-0,2013-07-14,ABIN,41940,0,-99,60.2733,0,10000145,MODELER,Hongkong
-0,2013-06-13,Auction,63889,0,11,87.9644,0,10000920,MODELER,Hongkong
-0,2013-05-05,FP-non GTC,1120,3,16,99.4791,0,10000720,ADMIN,Shanghai
-0,2012-03-30,Others,4943,0,14,56.9643,0,10000105,ANALYST,Beijing
-0,2012-01-13,FP-non GTC,139973,3,-99,15.8380,0,10000587,ANALYST,Beijing
-0,2012-09-02,ABIN,12688,0,13,69.4513,0,10000756,ANALYST,Beijing
-0,2013-08-08,Others,121153,0,11,29.2318,0,10000289,ADMIN,Shanghai
-0,2013-03-09,Others,99985,0,15,14.7661,0,10000453,MODELER,Hongkong
-0,2012-10-17,FP-non GTC,25147,0,11,96.1909,0,10000054,ADMIN,Shanghai
-0,2012-01-20,Others,73506,0,14,56.0157,0,10000909,ADMIN,Shanghai
-0,2012-04-15,FP-GTC,16145,0,12,94.6354,0,10000551,ANALYST,Beijing
-0,2013-08-08,Others,3838,0,13,85.7695,0,10000464,ANALYST,Beijing
-0,2013-01-21,Others,139973,0,13,64.5021,0,10000107,MODELER,Hongkong
-0,2012-06-17,Others,139973,0,-99,72.8065,0,10000495,MODELER,Hongkong
-0,2013-12-31,Others,20886,0,15,91.2326,0,10000746,MODELER,Hongkong
-0,2012-02-11,FP-non GTC,4943,0,14,28.3146,0,10000649,ANALYST,Beijing
-0,2013-10-01,Auction,155226,0,15,72.2196,0,10000576,MODELER,Hongkong
-0,2012-08-25,ABIN,223,0,15,17.6408,0,10000661,ANALYST,Beijing
-0,2012-07-10,Others,67698,0,15,70.9451,0,10000115,ANALYST,Beijing
-0,2013-12-27,FP-non GTC,26262,0,13,64.5694,0,10000740,MODELER,Hongkong
-0,2012-02-05,Auction,32996,15,12,9.9521,0,10000833,ANALYST,Beijing
-0,2012-11-07,FP-non GTC,25147,0,16,83.3886,0,10000494,MODELER,Hongkong
-0,2014-01-01,Others,45333,0,16,19.2606,0,10000869,ADMIN,Shanghai
-0,2013-10-05,Auction,50508,0,14,39.1465,0,10000904,ADMIN,Shanghai
-0,2012-02-25,FP-GTC,37831,0,11,12.4616,0,10000680,ANALYST,Beijing
-0,2012-05-16,Others,31519,0,12,66.9268,0,10000548,ADMIN,Shanghai
-0,2013-11-08,FP-GTC,100847,0,11,47.7510,0,10000699,ADMIN,Shanghai
-0,2012-03-15,ABIN,106246,0,16,96.1592,0,10000922,ADMIN,Shanghai
-0,2013-05-15,Auction,64076,0,15,37.7430,0,10000148,ADMIN,Shanghai
-0,2012-11-03,Auction,61323,0,15,14.3851,0,10000353,ADMIN,Shanghai
-0,2012-07-28,ABIN,175750,0,-99,45.5415,0,10000869,ANALYST,Beijing
-0,2013-06-26,FP-non GTC,95672,0,14,90.7320,0,10000507,ANALYST,Beijing
-0,2012-09-11,Others,223,0,15,10.5185,0,10000705,ANALYST,Beijing
-0,2012-09-24,FP-GTC,43479,0,16,3.4611,0,10000991,ANALYST,Beijing
-0,2013-09-13,FP-GTC,100847,0,-99,51.0213,0,10000871,ANALYST,Beijing
-0,2013-07-01,Others,132939,0,16,14.6584,0,10000859,ADMIN,Shanghai
-0,2012-06-13,Others,26262,0,-99,46.0446,0,10000041,ANALYST,Beijing
-0,2013-10-26,Auction,3838,0,12,24.8196,0,10000561,ADMIN,Shanghai
-0,2012-03-05,Others,26262,0,13,66.7748,0,10000859,ANALYST,Beijing
-0,2012-12-10,FP-GTC,20485,0,12,52.3473,0,10000171,ANALYST,Beijing
-0,2013-11-15,Others,2023,0,5,84.6955,0,10000451,ADMIN,Shanghai
-0,2013-12-12,ABIN,80135,0,11,95.0112,0,10000718,ANALYST,Beijing
-0,2013-04-16,ABIN,106340,15,16,14.6367,0,10000822,ANALYST,Beijing
-0,2012-03-10,Auction,161567,15,16,5.2800,0,10000081,ANALYST,Beijing
-0,2013-09-19,Auction,11848,0,11,27.6166,0,10000388,ADMIN,Shanghai
-0,2013-12-28,FP-GTC,216,0,15,90.1257,0,10000122,MODELER,Hongkong
-0,2012-01-26,ABIN,314,0,12,3.5634,0,10000912,ANALYST,Beijing
-0,2013-12-13,FP-GTC,158798,0,5,41.6652,0,10000485,MODELER,Hongkong
-0,2013-09-26,FP-non GTC,80135,0,11,20.5746,0,10000138,ANALYST,Beijing
-0,2012-01-20,Auction,62179,0,14,94.2904,0,10000310,ANALYST,Beijing
-0,2013-04-20,ABIN,963,0,5,68.3604,0,10000571,ADMIN,Shanghai
-0,2012-02-03,FP-GTC,164,0,11,94.0501,0,10000120,MODELER,Hongkong
-0,2013-10-14,Others,2023,0,12,84.9792,0,10000371,MODELER,Hongkong
-0,2013-08-19,FP-GTC,57990,3,14,57.0343,0,10000171,MODELER,Hongkong
-0,2012-06-18,Others,963,0,12,44.4186,0,10000343,MODELER,Hongkong
-0,2012-10-18,Others,31519,0,12,50.6753,0,10000875,MODELER,Hongkong
-0,2013-07-09,Others,36250,0,16,99.5251,0,10000446,MODELER,Hongkong
-0,2012-01-19,ABIN,38238,0,14,0.1259,0,10000242,ADMIN,Shanghai
-0,2013-05-19,FP-non GTC,13836,0,16,92.7668,0,10000895,MODELER,Hongkong
-0,2013-01-29,Others,95672,0,5,13.6012,0,10000843,ADMIN,Shanghai
-0,2013-01-30,ABIN,67698,0,5,13.9968,0,10000424,MODELER,Hongkong
-0,2012-09-02,FP-GTC,223,0,-99,38.0021,0,10000803,ADMIN,Shanghai
-0,2012-05-11,Auction,11848,0,13,7.1910,0,10000964,ADMIN,Shanghai
-0,2013-05-14,FP-non GTC,759,0,16,43.1720,0,10000123,ANALYST,Beijing
-0,2013-03-06,ABIN,3838,0,16,59.8866,0,10000653,ADMIN,Shanghai
-0,2012-08-23,FP-GTC,20213,0,16,91.3442,0,10000615,ANALYST,Beijing
-0,2013-03-24,FP-GTC,4943,0,-99,18.4365,0,10000718,MODELER,Hongkong
-0,2012-01-26,FP-non GTC,11554,0,14,41.6729,0,10000174,ADMIN,Shanghai
-0,2013-10-07,Others,108782,15,14,14.9130,0,10000643,ADMIN,Shanghai
-0,2013-07-25,Others,13987,0,-99,28.7021,0,10000154,MODELER,Hongkong
-0,2013-11-08,FP-non GTC,31673,0,13,83.8884,0,10000059,MODELER,Hongkong
-0,2013-01-06,ABIN,82494,15,12,74.4582,0,10000023,MODELER,Hongkong
-0,2013-01-21,FP-non GTC,13987,0,11,72.4276,0,10000541,ANALYST,Beijing
-0,2013-11-22,Auction,67698,0,11,53.1908,0,10000553,ANALYST,Beijing
-0,2012-02-02,FP-non GTC,175750,0,12,79.1160,0,10000121,ANALYST,Beijing
-0,2012-10-14,FP-GTC,24760,0,11,70.5894,0,10000677,ADMIN,Shanghai
-0,2012-10-20,ABIN,73506,0,11,3.7214,0,10000076,ANALYST,Beijing
-0,2013-12-01,Others,16145,0,15,54.8674,0,10000092,MODELER,Hongkong
-0,2012-11-07,FP-non GTC,53064,0,14,53.4385,0,10000267,MODELER,Hongkong
-0,2012-04-20,FP-non GTC,53064,0,15,76.5825,0,10000551,ANALYST,Beijing
-0,2012-11-18,Auction,50677,0,11,44.5149,0,10000924,MODELER,Hongkong
-0,2013-07-31,FP-GTC,51582,0,14,86.5325,0,10000652,MODELER,Hongkong
-0,2012-12-25,Others,31387,3,13,79.7624,0,10000495,ADMIN,Shanghai
-0,2012-08-10,ABIN,2635,0,12,54.5975,0,10000453,ADMIN,Shanghai
-0,2012-06-09,Others,31519,0,15,20.1828,0,10000226,ANALYST,Beijing
-0,2012-09-16,Others,44079,0,16,46.0626,0,10000193,ANALYST,Beijing
-0,2012-04-23,Others,16145,0,11,60.2064,0,10000058,ANALYST,Beijing
-0,2012-01-03,Others,164,0,15,94.1749,0,10000509,ADMIN,Shanghai
-0,2012-05-16,FP-GTC,13987,0,15,5.6834,0,10000052,ADMIN,Shanghai
-0,2012-07-24,FP-non GTC,16145,0,15,8.1625,0,10000036,ADMIN,Shanghai
-0,2013-01-01,FP-non GTC,32996,15,15,75.5057,0,10000393,ADMIN,Shanghai
-0,2013-01-28,FP-non GTC,155226,0,16,49.2395,0,10000966,ANALYST,Beijing
-0,2013-03-19,FP-GTC,20485,0,5,57.4433,0,10000138,ADMIN,Shanghai
-0,2013-02-03,FP-GTC,57784,0,5,11.8152,0,10000731,ADMIN,Shanghai
-0,2012-01-02,Others,53064,0,-99,45.8162,0,10000785,ANALYST,Beijing
-0,2013-02-23,ABIN,16145,0,14,25.1092,0,10000582,ANALYST,Beijing
-0,2013-04-19,Auction,159184,0,12,85.3510,0,10000422,ANALYST,Beijing
-0,2012-10-12,FP-non GTC,139973,0,11,95.7331,0,10000791,ANALYST,Beijing
-0,2012-04-20,FP-non GTC,87118,0,16,15.2148,0,10000621,ADMIN,Shanghai
-0,2013-04-30,Auction,53064,0,5,89.5035,0,10000377,MODELER,Hongkong
-0,2013-10-24,FP-non GTC,73506,0,12,84.0199,0,10000503,ANALYST,Beijing
-0,2012-01-08,Auction,63861,0,13,74.8860,0,10000589,ADMIN,Shanghai
-0,2012-05-21,Others,63861,3,16,63.7247,0,10000730,ANALYST,Beijing
-0,2013-01-29,Auction,24541,0,15,22.2189,0,10000167,ANALYST,Beijing
-0,2012-02-08,Auction,533,0,5,53.5867,0,10000564,MODELER,Hongkong
-0,2012-08-11,FP-non GTC,174053,3,13,0.5792,0,10000568,ANALYST,Beijing
-0,2012-07-05,FP-GTC,20886,0,12,31.1464,0,10000806,MODELER,Hongkong
-0,2012-01-08,Auction,156356,0,5,7.4293,0,10000638,MODELER,Hongkong
-0,2012-02-14,Others,65,0,14,62.6745,0,10000253,ADMIN,Shanghai
-0,2013-03-25,FP-non GTC,48027,0,-99,53.4890,0,10000899,MODELER,Hongkong
-0,2012-09-30,Others,57013,0,12,75.9109,0,10000274,MODELER,Hongkong
-0,2013-09-01,ABIN,32876,0,12,75.0498,0,10000086,ADMIN,Shanghai
-0,2013-11-11,FP-GTC,164,0,12,36.6051,0,10000521,MODELER,Hongkong
-0,2012-02-18,FP-GTC,57013,0,12,14.3117,0,10000763,ANALYST,Beijing
-0,2013-11-23,ABIN,139973,0,15,58.3344,0,10000787,ANALYST,Beijing
-0,2012-03-21,FP-non GTC,41940,0,15,38.2502,0,10000342,MODELER,Hongkong
-0,2012-02-24,Auction,57990,0,5,73.5795,0,10000175,ANALYST,Beijing
-0,2013-07-20,Auction,88750,0,-99,58.2532,0,10000122,ANALYST,Beijing
-0,2012-10-17,Others,43479,0,13,67.9585,0,10000516,ANALYST,Beijing
-0,2012-11-03,FP-non GTC,118687,3,13,90.9173,0,10000957,ADMIN,Shanghai
-0,2012-10-22,FP-GTC,60340,0,14,68.5877,0,10000502,ANALYST,Beijing
-0,2013-04-25,FP-GTC,11554,0,5,60.8280,0,10000074,ADMIN,Shanghai
-0,2012-10-23,FP-GTC,24760,0,13,6.0732,0,10000138,ANALYST,Beijing
-0,2013-04-29,ABIN,175750,0,11,8.0341,0,10000077,ADMIN,Shanghai
-0,2012-05-06,Auction,106340,15,14,8.0384,0,10000234,MODELER,Hongkong
-0,2012-07-15,ABIN,57784,0,14,27.1882,0,10000729,MODELER,Hongkong
-0,2012-10-15,Auction,67698,0,-99,63.1790,0,10000226,MODELER,Hongkong
-0,2013-03-22,FP-non GTC,57013,0,14,27.7251,0,10000658,ADMIN,Shanghai
-0,2013-08-12,FP-non GTC,11848,0,13,38.5597,0,10000020,ANALYST,Beijing
-0,2012-07-14,FP-GTC,80053,0,-99,81.0002,0,10000850,ADMIN,Shanghai
-0,2012-08-12,FP-non GTC,38238,0,11,58.6987,0,10000377,ANALYST,Beijing
-0,2013-09-09,FP-GTC,106246,0,11,5.0352,0,10000594,MODELER,Hongkong
-0,2013-02-11,FP-non GTC,57784,0,12,80.8420,0,10000657,ADMIN,Shanghai
-0,2013-03-09,Others,175750,0,14,87.9884,0,10000152,MODELER,Hongkong
-0,2013-12-18,FP-non GTC,20485,0,14,74.4627,0,10000272,MODELER,Hongkong
-0,2013-03-16,FP-non GTC,106246,0,5,64.1494,0,10000459,MODELER,Hongkong
-0,2012-09-06,FP-non GTC,80135,0,13,30.1506,0,10000269,MODELER,Hongkong
-0,2013-06-18,FP-non GTC,80135,0,-99,75.5826,0,10000706,ANALYST,Beijing
-0,2013-03-16,FP-GTC,156614,0,15,36.7157,0,10000761,MODELER,Hongkong
-0,2012-11-07,Others,1349,0,15,96.7575,0,10000612,ANALYST,Beijing
-0,2012-11-25,ABIN,95173,0,5,61.1186,0,10000364,MODELER,Hongkong
-0,2013-08-10,ABIN,31673,0,11,63.4095,0,10000421,ADMIN,Shanghai
-0,2012-02-17,ABIN,88750,0,14,87.8624,0,10000306,MODELER,Hongkong
-0,2013-03-29,ABIN,139973,0,16,9.1685,0,10000089,MODELER,Hongkong
-0,2012-12-27,ABIN,121153,0,12,88.7482,0,10000726,MODELER,Hongkong
-0,2013-10-13,FP-GTC,67698,0,16,20.8225,0,10000504,MODELER,Hongkong
-0,2012-09-26,ABIN,2023,0,11,83.6499,0,10000641,MODELER,Hongkong
-0,2012-08-01,Others,139973,0,-99,1.0542,0,10000202,MODELER,Hongkong
-0,2012-03-02,ABIN,113802,15,5,23.4439,0,10000068,MODELER,Hongkong
-0,2012-10-25,Others,10866,0,11,60.7453,0,10000770,ADMIN,Shanghai
-0,2013-01-07,FP-non GTC,20485,0,16,16.4177,0,10000698,ADMIN,Shanghai
-0,2012-03-18,FP-non GTC,46575,0,15,55.2768,0,10000962,MODELER,Hongkong
-0,2012-07-09,FP-GTC,106246,0,14,99.6346,0,10000563,MODELER,Hongkong
-0,2012-09-26,FP-GTC,314,0,13,45.8302,0,10000769,ANALYST,Beijing
-0,2012-01-14,FP-non GTC,15868,0,16,47.5496,0,10000869,ADMIN,Shanghai
-0,2012-01-01,ABIN,63861,0,13,76.1393,0,10000028,ADMIN,Shanghai
-0,2012-08-15,FP-GTC,26249,0,5,40.7448,0,10000419,ADMIN,Shanghai
-0,2012-09-24,FP-non GTC,43398,0,12,54.0864,0,10000688,MODELER,Hongkong
-0,2013-10-13,Others,533,0,-99,58.0312,0,10000658,MODELER,Hongkong
-0,2012-07-13,FP-GTC,148324,15,11,71.6067,0,10000006,ADMIN,Shanghai
-0,2012-01-21,FP-GTC,32996,15,11,86.8077,0,10000928,ADMIN,Shanghai
-0,2012-04-04,Others,63861,3,16,85.2671,0,10000648,MODELER,Hongkong
-0,2012-10-20,FP-non GTC,31519,0,13,99.1930,0,10000469,ANALYST,Beijing
-0,2013-12-28,FP-GTC,1504,0,5,14.9821,0,10000342,ANALYST,Beijing
-0,2013-06-19,Others,25147,0,5,77.4671,0,10000212,ANALYST,Beijing
-0,2013-05-04,Others,13836,0,11,13.4655,0,10000331,MODELER,Hongkong
-0,2012-06-28,ABIN,145970,0,15,74.3304,0,10000900,ANALYST,Beijing
-0,2012-12-24,FP-non GTC,156614,0,12,79.4508,0,10000743,MODELER,Hongkong
-0,2013-07-17,FP-GTC,139973,0,13,30.0555,0,10000949,ADMIN,Shanghai
-0,2013-11-23,Others,31519,3,11,9.0845,0,10000883,MODELER,Hongkong
-0,2013-01-15,Others,164261,0,12,31.5563,0,10000029,ANALYST,Beijing
-0,2012-04-15,FP-non GTC,20213,0,-99,55.6917,0,10000513,ANALYST,Beijing
-0,2013-01-20,FP-non GTC,24760,0,15,71.7279,0,10000274,ANALYST,Beijing
-0,2012-11-13,FP-GTC,95173,0,5,95.7043,0,10000418,ANALYST,Beijing
-0,2012-09-03,ABIN,57990,0,12,1.5845,0,10000703,ANALYST,Beijing
-0,2012-01-02,FP-non GTC,57990,3,16,12.3706,0,10000090,ADMIN,Shanghai
-0,2013-12-06,Auction,67703,3,5,70.4134,0,10000753,MODELER,Hongkong
-0,2012-06-09,Others,50677,0,12,88.7297,0,10000990,MODELER,Hongkong
-0,2012-05-17,ABIN,31519,0,14,37.7070,0,10000326,ADMIN,Shanghai
-0,2012-03-03,Others,156356,0,16,50.7844,0,10000693,MODELER,Hongkong
-0,2012-05-21,Auction,44079,0,5,86.7590,0,10000795,ADMIN,Shanghai
-0,2013-10-15,Auction,26262,0,15,56.3327,0,10000077,MODELER,Hongkong
-0,2013-12-27,ABIN,20213,0,13,96.1815,0,10000195,ADMIN,Shanghai
-0,2012-02-15,ABIN,314,0,5,6.5869,0,10000753,ANALYST,Beijing
-0,2012-08-17,FP-non GTC,6762,0,15,41.0782,0,10000797,ADMIN,Shanghai
-0,2013-04-29,Auction,145970,0,15,11.0876,0,10000208,ADMIN,Shanghai
-0,2013-10-27,Auction,80053,0,14,81.7435,0,10000310,ADMIN,Shanghai
-0,2012-12-21,FP-GTC,63861,0,13,57.9491,0,10000971,MODELER,Hongkong
-0,2013-07-29,ABIN,45333,0,12,33.5405,0,10000475,ADMIN,Shanghai
-0,2012-04-18,Auction,64076,0,13,83.3621,0,10000697,ANALYST,Beijing
-0,2012-12-14,FP-non GTC,63889,0,16,0.9640,0,10000607,ANALYST,Beijing
-0,2013-06-07,Auction,145970,0,13,6.1316,0,10000450,ANALYST,Beijing
-0,2012-11-27,Others,164,0,15,53.7718,0,10000305,ADMIN,Shanghai
-0,2012-08-03,ABIN,61323,0,15,62.2945,0,10000214,ANALYST,Beijing
-0,2012-07-07,ABIN,75665,0,15,77.0551,0,10000094,ANALYST,Beijing
-0,2012-08-06,FP-non GTC,99985,0,13,39.1253,0,10000609,MODELER,Hongkong
-0,2012-10-01,Auction,759,0,15,69.1790,0,10000199,MODELER,Hongkong
-0,2012-03-22,Auction,20865,0,5,40.7800,0,10000392,MODELER,Hongkong
-0,2012-02-06,FP-non GTC,132939,0,11,66.8705,0,10000207,ADMIN,Shanghai
-0,2012-10-17,FP-non GTC,63861,3,14,35.8018,0,10000096,ANALYST,Beijing
-0,2013-02-21,Others,41940,0,5,87.4721,0,10000858,MODELER,Hongkong
-0,2012-11-16,FP-GTC,57784,0,15,96.2799,0,10000537,ADMIN,Shanghai
-0,2012-01-10,Others,158666,15,11,7.4077,0,10000190,ADMIN,Shanghai
-0,2013-10-29,FP-non GTC,65,0,-99,21.3439,0,10000182,ADMIN,Shanghai
-0,2013-07-30,Auction,103178,15,-99,94.8679,0,10000943,ADMIN,Shanghai
-0,2012-08-05,FP-non GTC,175750,0,14,10.0980,0,10000212,ADMIN,Shanghai
-0,2012-07-29,ABIN,24760,0,13,44.5270,0,10000168,ANALYST,Beijing
-0,2013-04-27,FP-GTC,57990,3,-99,75.6664,0,10000878,ANALYST,Beijing
-0,2012-12-06,FP-GTC,37831,0,11,57.1191,0,10000090,ADMIN,Shanghai
-0,2013-08-29,FP-GTC,164,0,16,75.2345,0,10000689,ANALYST,Beijing
-0,2012-08-30,FP-GTC,63861,0,12,21.2099,0,10000643,MODELER,Hongkong
-0,2013-05-30,ABIN,57013,0,15,28.8410,0,10000290,ADMIN,Shanghai
-0,2013-10-17,ABIN,50677,0,-99,16.3836,0,10000705,ANALYST,Beijing
-0,2012-04-25,FP-GTC,67698,0,11,52.3502,0,10000257,ANALYST,Beijing
-0,2013-08-18,ABIN,759,0,16,23.8258,0,10000911,ADMIN,Shanghai
-0,2013-02-24,Others,13836,0,-99,40.6826,0,10000399,ADMIN,Shanghai
-0,2012-07-22,FP-non GTC,158798,0,15,94.1886,0,10000705,ANALYST,Beijing
-0,2012-08-05,FP-GTC,100847,0,-99,74.1500,0,10000797,ADMIN,Shanghai
-0,2012-12-30,Auction,31519,0,11,69.1499,0,10000576,ANALYST,Beijing
-0,2013-05-18,Auction,63864,3,14,44.5408,0,10000232,ANALYST,Beijing
-0,2012-11-01,ABIN,53064,0,15,19.9817,0,10000065,ADMIN,Shanghai
-0,2013-06-25,FP-GTC,156614,0,16,91.4652,0,10000326,ANALYST,Beijing
-0,2013-07-11,FP-non GTC,10058,3,5,92.6671,0,10000787,ADMIN,Shanghai
-0,2013-01-19,FP-non GTC,13987,0,12,49.0313,0,10000556,ADMIN,Shanghai
-0,2013-06-17,Auction,94847,0,13,95.5377,0,10000047,ANALYST,Beijing
-0,2012-12-23,Others,64076,0,-99,50.1173,0,10000063,MODELER,Hongkong
-0,2013-01-07,FP-non GTC,67698,0,5,6.5979,0,10000412,ADMIN,Shanghai
-0,2012-01-20,ABIN,175750,3,16,79.6931,0,10000270,ADMIN,Shanghai
-0,2013-01-14,Others,95672,3,12,31.7315,0,10000044,ANALYST,Beijing
-0,2013-02-22,Others,26249,0,16,43.7969,0,10000634,ADMIN,Shanghai
-0,2013-04-13,FP-non GTC,156614,0,16,79.3213,0,10000321,ADMIN,Shanghai
-0,2013-09-18,FP-non GTC,43398,0,5,17.3702,0,10000621,MODELER,Hongkong
-0,2013-09-05,ABIN,67703,3,11,55.6439,0,10000784,ANALYST,Beijing
-0,2013-05-25,FP-GTC,43398,0,15,73.0548,0,10000921,MODELER,Hongkong
-0,2012-10-06,Others,100847,0,16,77.0258,0,10000606,MODELER,Hongkong
-0,2013-11-08,Others,164261,0,11,16.6959,0,10000136,ANALYST,Beijing
-0,2012-04-13,FP-non GTC,3838,0,5,68.4347,0,10000451,ADMIN,Shanghai
-0,2012-07-03,FP-GTC,63861,0,-99,89.5962,0,10000893,ADMIN,Shanghai
-0,2012-02-21,Auction,40059,3,-99,84.7455,0,10000613,MODELER,Hongkong
-0,2012-02-25,FP-non GTC,759,0,13,23.9258,0,10000826,MODELER,Hongkong
-0,2013-10-30,FP-non GTC,57990,0,16,88.4859,0,10000782,MODELER,Hongkong
-0,2013-10-12,FP-non GTC,57784,0,14,85.8986,0,10000220,MODELER,Hongkong
-0,2012-08-15,FP-GTC,223,0,12,32.1974,0,10000316,ANALYST,Beijing
-0,2012-10-18,FP-GTC,15115,0,16,52.5243,0,10000353,ADMIN,Shanghai
-0,2013-11-09,FP-GTC,20886,0,13,94.0128,0,10000690,MODELER,Hongkong
-0,2012-09-27,ABIN,31673,0,12,24.1332,0,10000404,ANALYST,Beijing
-0,2012-05-08,FP-GTC,95672,0,16,88.8853,0,10000984,ADMIN,Shanghai
-0,2013-01-14,Others,95173,0,12,86.3987,0,10000501,ADMIN,Shanghai
-0,2012-12-02,Auction,152801,0,-99,71.8799,0,10000021,ADMIN,Shanghai
-0,2012-03-13,ABIN,31519,3,15,96.8998,0,10000188,ADMIN,Shanghai
-0,2013-06-15,Auction,121153,0,14,66.2729,0,10000101,ANALYST,Beijing
-0,2012-04-11,Others,63861,0,15,88.0097,0,10000536,ADMIN,Shanghai
-0,2013-01-25,FP-non GTC,1357,0,16,49.8991,0,10000637,ANALYST,Beijing
-0,2013-10-17,FP-GTC,106246,0,15,92.2507,0,10000046,MODELER,Hongkong
-0,2012-10-04,Others,4943,0,13,88.8498,0,10000215,ADMIN,Shanghai
-0,2013-05-14,Auction,314,0,13,77.3441,0,10000900,ANALYST,Beijing
-0,2013-03-17,FP-non GTC,759,0,16,17.9719,0,10000759,MODELER,Hongkong
-0,2013-01-20,FP-non GTC,51582,0,16,3.6644,0,10000961,ADMIN,Shanghai
-0,2013-03-20,FP-non GTC,57990,0,12,9.3680,0,10000846,ANALYST,Beijing
-0,2012-06-06,FP-non GTC,165888,0,16,9.4584,0,10000312,ADMIN,Shanghai
-0,2012-12-13,Auction,43479,0,16,84.0632,0,10000349,MODELER,Hongkong
-0,2012-05-13,FP-non GTC,139973,3,5,37.3510,0,10000790,MODELER,Hongkong
-0,2013-03-27,Auction,48027,0,5,75.7167,0,10000424,MODELER,Hongkong
-0,2013-08-08,FP-GTC,37831,0,-99,27.7800,0,10000637,ANALYST,Beijing
-0,2012-04-06,ABIN,314,0,12,18.3274,0,10000749,MODELER,Hongkong
-0,2013-10-11,FP-non GTC,57013,0,14,39.1868,0,10000599,MODELER,Hongkong
-0,2012-01-18,FP-GTC,41940,0,12,94.5165,0,10000102,MODELER,Hongkong
-0,2013-05-20,ABIN,50677,0,16,25.6136,0,10000423,ANALYST,Beijing
-0,2012-06-24,FP-GTC,963,0,13,20.9442,0,10000069,ADMIN,Shanghai
-0,2013-04-01,ABIN,75665,0,12,65.3307,0,10000543,MODELER,Hongkong
-0,2012-02-05,ABIN,50508,0,-99,69.4516,0,10000623,ANALYST,Beijing
-0,2012-06-24,ABIN,314,0,5,13.8612,0,10000347,ANALYST,Beijing
-0,2013-12-07,Others,1349,0,16,10.8619,0,10000784,MODELER,Hongkong
-0,2013-03-01,ABIN,73506,0,11,7.7818,0,10000882,ADMIN,Shanghai
-0,2012-08-24,Auction,45333,0,16,94.9583,0,10000495,ANALYST,Beijing
-0,2012-08-04,FP-non GTC,20886,0,15,69.7300,0,10000428,MODELER,Hongkong
-0,2012-11-08,Auction,31519,0,15,41.4423,0,10000431,MODELER,Hongkong
-0,2013-08-07,FP-GTC,156356,0,13,44.6853,0,10000305,ANALYST,Beijing
-0,2013-09-25,ABIN,43398,0,16,46.5536,0,10000387,ANALYST,Beijing
-0,2012-04-26,FP-non GTC,95672,0,13,30.9202,0,10000591,MODELER,Hongkong
-0,2012-03-30,Others,159184,0,12,58.3993,0,10000381,ADMIN,Shanghai
-0,2012-04-25,Auction,73506,0,14,46.1501,0,10000010,ANALYST,Beijing
-0,2012-09-13,FP-GTC,20485,0,5,2.4112,0,10000959,ADMIN,Shanghai
-0,2013-09-27,ABIN,80287,0,-99,64.4361,0,10000770,ANALYST,Beijing
-0,2013-01-17,Others,36250,0,11,73.5773,0,10000948,ADMIN,Shanghai
-0,2012-07-07,Auction,103324,15,16,4.8559,0,10000123,MODELER,Hongkong
-0,2013-08-15,ABIN,13836,0,16,25.8438,0,10000851,ANALYST,Beijing
-0,2012-07-07,Others,12688,0,5,3.4934,0,10000096,MODELER,Hongkong
-0,2012-06-03,Auction,80135,0,12,17.8258,0,10000144,ANALYST,Beijing
-0,2013-12-24,FP-GTC,60340,0,11,22.6409,0,10000341,MODELER,Hongkong
-0,2012-10-06,ABIN,36250,0,5,7.4322,0,10000384,ADMIN,Shanghai
-0,2013-01-03,Auction,175750,0,15,14.1976,0,10000366,ADMIN,Shanghai
-0,2013-04-15,Auction,88750,0,11,98.6057,0,10000584,MODELER,Hongkong
-0,2013-06-03,FP-non GTC,1349,0,15,11.0419,0,10000866,ANALYST,Beijing
-0,2013-01-30,FP-GTC,2635,0,14,54.5175,0,10000959,ANALYST,Beijing
-0,2013-08-27,FP-non GTC,26249,0,13,50.0365,0,10000289,MODELER,Hongkong
-0,2012-05-14,FP-non GTC,9426,3,5,60.0224,0,10000730,ADMIN,Shanghai
-0,2012-10-16,FP-non GTC,16145,0,-99,53.0896,0,10000195,MODELER,Hongkong
-0,2012-09-24,FP-GTC,57013,0,14,81.7929,0,10000498,MODELER,Hongkong
-0,2012-08-20,FP-non GTC,25147,0,-99,30.7605,0,10000242,ADMIN,Shanghai
-0,2012-02-19,Others,94847,0,13,20.6395,0,10000707,ANALYST,Beijing
-0,2013-11-14,ABIN,50508,0,15,91.9217,0,10000208,ADMIN,Shanghai
-0,2012-07-10,Others,95672,0,13,21.1886,0,10000762,ADMIN,Shanghai
-0,2012-03-14,ABIN,44079,0,13,89.6838,0,10000227,ADMIN,Shanghai
-0,2012-01-17,FP-non GTC,314,0,14,44.3066,0,10000251,ADMIN,Shanghai
-0,2012-02-27,FP-non GTC,15868,0,14,80.8427,0,10000741,ANALYST,Beijing
-0,2012-10-23,Others,1161,3,5,54.0104,0,10000289,ADMIN,Shanghai
-0,2013-06-12,Others,53064,0,12,87.1336,0,10000871,ANALYST,Beijing
-0,2013-03-06,Auction,34273,100,15,6.7044,0,10000269,MODELER,Hongkong
-0,2012-06-16,Others,533,0,14,43.7104,0,10000172,ADMIN,Shanghai
-0,2012-12-19,FP-GTC,15868,0,15,94.1727,0,10000366,ANALYST,Beijing
-0,2012-07-21,ABIN,121153,0,12,42.3437,0,10000688,ANALYST,Beijing
-0,2013-08-19,FP-non GTC,65,0,11,3.0275,0,10000055,MODELER,Hongkong
-0,2012-08-08,Auction,15687,0,14,72.9505,0,10000725,ADMIN,Shanghai
-0,2013-12-13,FP-GTC,4943,0,-99,37.7781,0,10000932,MODELER,Hongkong
-0,2013-05-18,FP-GTC,3838,0,14,45.1642,0,10000370,ANALYST,Beijing
-0,2012-01-31,Auction,25147,0,14,78.6580,0,10000721,MODELER,Hongkong
-0,2013-12-05,FP-GTC,62179,0,12,76.4692,0,10000423,MODELER,Hongkong
-0,2012-03-07,Auction,175750,0,15,19.5357,0,10000053,MODELER,Hongkong
-0,2013-09-30,Others,100847,0,12,38.2299,0,10000772,ADMIN,Shanghai
-0,2013-01-07,Others,15115,0,12,82.5099,0,10000864,ADMIN,Shanghai
-0,2013-11-04,FP-non GTC,57013,0,-99,61.3731,0,10000335,MODELER,Hongkong
-0,2012-08-11,FP-non GTC,31673,0,12,12.7001,0,10000303,MODELER,Hongkong
-0,2012-12-30,ABIN,156356,0,14,99.3562,0,10000427,ANALYST,Beijing
-0,2013-05-19,Others,113593,15,11,31.1634,0,10000361,ADMIN,Shanghai
-0,2013-06-03,ABIN,314,0,13,32.6968,0,10000373,ANALYST,Beijing
-0,2013-06-29,Auction,15808,15,12,18.3967,0,10000484,ADMIN,Shanghai
-0,2012-06-10,FP-GTC,61323,0,13,10.8143,0,10000403,ADMIN,Shanghai
-0,2012-01-29,FP-GTC,1349,0,15,0.4358,0,10000639,ANALYST,Beijing
-0,2013-05-30,FP-non GTC,759,0,14,19.5920,0,10000116,MODELER,Hongkong
-0,2013-07-28,ABIN,15868,0,14,59.7123,0,10000668,ADMIN,Shanghai
-0,2013-03-23,Auction,165888,0,12,67.1201,0,10000063,MODELER,Hongkong
-0,2012-05-29,FP-GTC,118687,3,-99,98.2030,0,10000886,ADMIN,Shanghai
-0,2013-09-15,FP-non GTC,156614,0,5,43.1795,0,10000302,ANALYST,Beijing
-0,2012-05-21,FP-GTC,223,0,-99,66.2850,0,10000118,ANALYST,Beijing
-0,2012-04-03,FP-non GTC,26262,0,12,17.5241,0,10000440,ADMIN,Shanghai
-0,2012-05-22,ABIN,44079,0,16,25.2405,0,10000183,ANALYST,Beijing
-0,2014-01-01,Others,50508,0,16,92.5843,0,10000911,MODELER,Hongkong
-0,2012-04-08,Others,16145,3,12,90.2242,0,10000825,ADMIN,Shanghai
-0,2013-11-27,ABIN,95672,0,16,90.9380,0,10000829,ANALYST,Beijing
-0,2013-03-22,Auction,41940,0,15,72.0648,0,10000795,ANALYST,Beijing
-0,2012-04-06,Others,64076,0,14,86.9185,0,10000356,ADMIN,Shanghai
-0,2013-05-02,Others,156356,0,11,41.6871,0,10000122,ANALYST,Beijing
-0,2012-04-02,Others,132939,0,12,75.8372,0,10000395,ADMIN,Shanghai
-0,2012-06-29,ABIN,26262,0,13,83.6043,0,10000120,ADMIN,Shanghai
-0,2012-07-06,FP-GTC,11554,0,16,38.4329,0,10000352,MODELER,Hongkong
-0,2012-06-10,ABIN,156614,0,-99,94.1812,0,10000280,ANALYST,Beijing
-0,2012-04-05,Auction,164261,0,12,0.9691,0,10000480,ANALYST,Beijing
-0,2012-11-02,Auction,31519,0,11,98.0505,0,10000893,MODELER,Hongkong
-0,2012-05-20,Auction,50508,0,15,61.9439,0,10000363,ANALYST,Beijing
-0,2012-03-31,Auction,80135,0,16,11.1543,0,10000692,MODELER,Hongkong
-0,2012-07-01,FP-non GTC,63889,0,-99,86.6557,0,10000402,MODELER,Hongkong
-0,2013-01-04,ABIN,41940,0,-99,48.4505,0,10000296,ANALYST,Beijing
-0,2013-02-10,FP-non GTC,63861,0,13,60.3535,0,10000214,ADMIN,Shanghai
-0,2012-03-25,Others,73506,0,11,74.2113,0,10000801,ANALYST,Beijing
-0,2013-07-23,FP-non GTC,53064,0,16,69.2368,0,10000542,MODELER,Hongkong
-0,2012-04-09,Auction,11848,0,15,76.1720,0,10000555,ADMIN,Shanghai
-0,2012-08-01,Others,12688,0,5,85.4589,0,10000130,ADMIN,Shanghai
-0,2012-07-15,FP-non GTC,31519,3,-99,17.8485,0,10000045,MODELER,Hongkong
-0,2013-10-06,ABIN,1349,0,11,52.2780,0,10000622,MODELER,Hongkong
-0,2012-10-26,Auction,25147,0,13,60.9912,0,10000379,ADMIN,Shanghai
-0,2013-01-04,FP-non GTC,37831,0,15,61.0134,0,10000785,ADMIN,Shanghai
-0,2012-03-24,Auction,139973,0,-99,8.1533,0,10000487,ADMIN,Shanghai
-0,2012-12-30,Auction,6762,0,-99,77.8179,0,10000645,ADMIN,Shanghai
-0,2012-10-03,ABIN,103178,15,12,15.2201,0,10000824,MODELER,Hongkong
-0,2012-04-18,FP-non GTC,50508,0,14,11.9715,0,10000012,MODELER,Hongkong
-0,2012-09-30,FP-non GTC,31673,0,12,90.0864,0,10000281,MODELER,Hongkong
-0,2013-03-24,ABIN,4943,0,12,11.0294,0,10000785,ADMIN,Shanghai
-0,2012-05-02,Others,87118,0,14,52.6549,0,10000924,ADMIN,Shanghai
-0,2013-05-03,FP-GTC,24760,0,5,8.9077,0,10000758,MODELER,Hongkong
-0,2012-08-05,FP-non GTC,38238,0,11,0.8463,0,10000066,MODELER,Hongkong
-0,2012-08-15,Auction,67698,0,11,23.6278,0,10000085,ADMIN,Shanghai
-0,2013-04-04,Auction,164261,0,13,52.3718,0,10000965,ADMIN,Shanghai
-0,2013-04-18,ABIN,25147,0,14,71.7687,0,10000157,ANALYST,Beijing
-0,2013-11-09,ABIN,43479,0,12,39.9269,0,10000024,ANALYST,Beijing
-0,2013-05-02,FP-non GTC,175750,0,12,17.6149,0,10000862,ANALYST,Beijing
-0,2012-09-01,ABIN,50508,0,14,99.1518,0,10000746,ANALYST,Beijing
-0,2013-02-23,FP-non GTC,139255,15,-99,74.6182,0,10000447,ANALYST,Beijing
-0,2012-01-19,FP-non GTC,6762,0,13,0.1297,0,10000189,MODELER,Hongkong
-0,2012-11-10,Auction,113802,15,-99,11.9583,0,10000596,ANALYST,Beijing
-0,2012-12-11,FP-non GTC,95173,0,5,67.9416,0,10000582,ADMIN,Shanghai
-0,2012-01-05,ABIN,2635,0,11,72.3723,0,10000375,ANALYST,Beijing
-0,2012-05-04,FP-non GTC,43479,0,13,79.1307,0,10000944,ADMIN,Shanghai
-0,2013-07-20,ABIN,63861,0,13,86.7155,0,10000274,MODELER,Hongkong
-0,2013-08-25,FP-GTC,80053,0,5,11.7108,0,10000059,MODELER,Hongkong
-0,2012-10-24,ABIN,38238,0,5,79.2964,0,10000388,MODELER,Hongkong
-0,2012-01-10,ABIN,73506,0,5,3.8878,0,10000895,ANALYST,Beijing
-0,2013-07-11,Auction,174106,3,12,46.7087,0,10000683,ANALYST,Beijing
-0,2013-06-16,FP-GTC,61323,0,15,64.0224,0,10000121,ADMIN,Shanghai
-0,2013-06-23,ABIN,63889,0,5,59.2766,0,10000466,MODELER,Hongkong
-0,2013-01-25,Others,156356,0,14,79.9992,0,10000611,ANALYST,Beijing
-0,2013-10-09,Auction,50508,0,16,70.9682,0,10000009,MODELER,Hongkong
-0,2013-05-19,Auction,25147,0,16,8.0973,0,10000731,ADMIN,Shanghai
-0,2012-10-14,Auction,67698,0,5,49.0497,0,10000605,ADMIN,Shanghai
-0,2012-06-08,Auction,65,0,14,76.5149,0,10000165,MODELER,Hongkong
-0,2012-12-21,FP-GTC,15868,0,5,45.9224,0,10000215,ADMIN,Shanghai
-0,2012-12-02,Auction,1357,0,15,8.9337,0,10000730,ANALYST,Beijing
-0,2013-11-27,ABIN,24760,0,11,62.4675,0,10000932,ADMIN,Shanghai
-0,2013-11-24,Auction,95173,0,16,16.7927,0,10000795,ANALYST,Beijing
-0,2013-11-30,ABIN,164,0,11,10.8897,0,10000914,MODELER,Hongkong
-0,2012-12-22,Auction,15868,0,15,7.4153,0,10000540,MODELER,Hongkong
-0,2012-05-13,FP-non GTC,26249,0,5,58.8647,0,10000898,MODELER,Hongkong
-0,2013-06-22,ABIN,95672,3,12,71.8628,0,10000026,ANALYST,Beijing
-0,2013-05-22,ABIN,63861,0,11,71.8836,0,10000650,ADMIN,Shanghai
-0,2012-11-17,FP-GTC,32876,0,12,35.6019,0,10000959,ADMIN,Shanghai
-0,2013-04-13,Auction,38238,0,5,21.7443,0,10000036,ANALYST,Beijing
-0,2012-09-09,FP-non GTC,87118,0,14,46.2858,0,10000512,MODELER,Hongkong
-0,2013-08-23,FP-non GTC,41940,0,11,98.4779,0,10000844,MODELER,Hongkong
-0,2012-09-02,FP-non GTC,43398,0,12,91.8543,0,10000917,ANALYST,Beijing
-0,2012-11-23,Others,145970,0,11,43.8631,0,10000997,ANALYST,Beijing
-0,2012-01-22,FP-non GTC,164261,0,16,74.9772,0,10000091,MODELER,Hongkong
-0,2012-05-02,ABIN,152801,0,13,15.2794,0,10000649,ADMIN,Shanghai
-0,2013-08-14,Others,50677,0,13,26.5329,0,10000275,MODELER,Hongkong
-0,2012-06-04,Others,156614,0,14,42.7810,0,10000347,ANALYST,Beijing
-0,2012-08-04,FP-non GTC,145970,0,15,92.6953,0,10000622,ADMIN,Shanghai
-0,2012-08-15,Auction,32876,0,16,35.2015,0,10000533,MODELER,Hongkong
-0,2012-11-05,Auction,95672,0,11,0.5233,0,10000965,MODELER,Hongkong
-0,2013-10-12,ABIN,165888,0,11,27.3564,0,10000036,ADMIN,Shanghai
-0,2012-10-22,ABIN,20485,0,14,28.6742,0,10000448,ANALYST,Beijing
-0,2012-07-02,Auction,20213,0,15,81.3332,0,10000484,ADMIN,Shanghai
-0,2013-01-13,Others,152801,0,11,3.3406,0,10000124,MODELER,Hongkong
-0,2012-05-17,Others,132939,0,15,55.3503,0,10000086,MODELER,Hongkong
-0,2013-02-05,Others,48904,0,15,25.2340,0,10000246,MODELER,Hongkong
-0,2013-09-13,FP-GTC,32876,0,-99,10.7672,0,10000729,ANALYST,Beijing
-0,2012-06-14,ABIN,20865,0,14,47.9841,0,10000406,ADMIN,Shanghai
-0,2013-02-11,Auction,152801,0,5,86.4355,0,10000050,ANALYST,Beijing
-0,2012-12-13,Auction,50508,0,5,72.5114,0,10000715,ANALYST,Beijing
-0,2013-11-30,Auction,3838,0,-99,6.8517,0,10000706,ADMIN,Shanghai
-0,2013-03-15,FP-non GTC,20865,0,14,93.3040,0,10000926,MODELER,Hongkong
-0,2012-08-12,FP-GTC,57784,0,-99,18.4045,0,10000231,ADMIN,Shanghai
-0,2013-10-19,Others,1161,3,14,79.1353,0,10000561,ADMIN,Shanghai
-0,2013-02-17,Others,31519,0,-99,49.0409,0,10000904,ADMIN,Shanghai
-0,2012-03-30,FP-non GTC,314,0,11,93.6413,0,10000041,ANALYST,Beijing
-0,2012-08-26,Others,175750,0,-99,46.6557,0,10000719,ANALYST,Beijing
-0,2012-12-26,Auction,139973,0,15,6.9809,0,10000044,MODELER,Hongkong
-0,2013-01-30,Others,159184,0,13,45.4599,0,10000131,ANALYST,Beijing
-0,2012-04-27,Auction,48904,0,5,16.3472,0,10000157,MODELER,Hongkong
-0,2012-11-10,ABIN,16145,0,13,0.4693,0,10000668,ANALYST,Beijing
-0,2012-05-13,Auction,121153,0,5,24.6420,0,10000314,MODELER,Hongkong
-0,2012-02-01,FP-GTC,6762,0,13,5.9417,0,10000851,MODELER,Hongkong
-0,2012-07-16,Auction,95672,0,-99,11.9934,0,10000828,MODELER,Hongkong
-0,2012-09-21,Auction,106246,0,5,39.0057,0,10000826,ANALYST,Beijing
-0,2012-10-20,FP-GTC,314,0,16,5.5339,0,10000011,ANALYST,Beijing
-0,2013-04-29,FP-non GTC,100847,0,13,3.3872,0,10000840,ADMIN,Shanghai
-0,2013-02-16,FP-non GTC,43398,0,13,3.4171,0,10000106,ANALYST,Beijing
-0,2013-09-11,FP-GTC,63889,0,12,15.4662,0,10000004,MODELER,Hongkong
-0,2012-12-18,Others,80287,0,15,71.3090,0,10000722,MODELER,Hongkong
-0,2013-09-14,FP-non GTC,20865,0,-99,98.0987,0,10000591,ADMIN,Shanghai
-0,2013-01-27,FP-non GTC,57990,3,14,84.9483,0,10000304,ANALYST,Beijing
-0,2013-02-07,Others,95672,0,14,9.7034,0,10000894,ANALYST,Beijing
-0,2013-03-24,FP-non GTC,38238,0,-99,98.5328,0,10000286,MODELER,Hongkong
-0,2012-01-05,Others,164,0,15,21.3336,0,10000151,ADMIN,Shanghai
-0,2012-11-14,Auction,57990,0,12,91.1773,0,10000087,ADMIN,Shanghai
-0,2013-03-24,Auction,13987,0,13,5.9953,0,10000551,ADMIN,Shanghai
-0,2013-12-26,FP-GTC,32876,0,11,86.1904,0,10000012,MODELER,Hongkong
-0,2013-06-23,FP-non GTC,1504,0,12,9.4689,0,10000720,ANALYST,Beijing
-0,2012-01-11,FP-GTC,57013,0,13,96.6705,0,10000790,ADMIN,Shanghai
-0,2012-08-30,FP-non GTC,62179,0,5,22.4244,0,10000403,MODELER,Hongkong
-0,2012-09-01,ABIN,61323,0,12,30.1513,0,10000283,ANALYST,Beijing
-0,2013-04-20,Auction,16145,3,12,77.9327,0,10000043,MODELER,Hongkong
-0,2013-10-03,Others,963,0,14,82.3371,0,10000002,MODELER,Hongkong
-0,2012-10-23,ABIN,45333,0,16,86.7017,0,10000180,MODELER,Hongkong
-0,2013-10-09,ABIN,63889,0,-99,33.9942,0,10000485,ADMIN,Shanghai
-0,2013-04-28,ABIN,73506,0,5,22.6563,0,10000070,ANALYST,Beijing
-0,2013-07-07,ABIN,57990,0,11,11.7659,0,10000834,ADMIN,Shanghai
-0,2012-01-04,FP-non GTC,165888,0,16,78.7873,0,10000743,ANALYST,Beijing
-0,2012-05-05,ABIN,158666,15,16,55.1036,0,10000372,ANALYST,Beijing
-0,2012-08-04,ABIN,43479,0,13,61.3469,0,10000425,MODELER,Hongkong
-0,2013-02-18,Others,161567,15,5,43.5109,0,10000315,MODELER,Hongkong
-0,2013-08-09,FP-GTC,161567,15,14,0.9756,0,10000420,MODELER,Hongkong
-0,2012-04-30,Others,65,0,12,31.5741,0,10000858,ANALYST,Beijing
-0,2013-10-16,FP-non GTC,16509,0,15,8.4323,0,10000376,MODELER,Hongkong
-0,2013-11-06,FP-GTC,15115,0,12,91.7204,0,10000495,ADMIN,Shanghai
-0,2012-04-13,ABIN,37831,0,16,86.9150,0,10000947,MODELER,Hongkong
-0,2013-04-21,FP-GTC,95672,0,-99,60.6048,0,10000052,ANALYST,Beijing
-0,2013-12-04,FP-GTC,121153,0,13,9.3639,0,10000384,ADMIN,Shanghai
-0,2012-08-03,Others,50508,0,13,74.2474,0,10000103,ANALYST,Beijing
-0,2013-12-29,FP-GTC,1357,0,5,46.9382,0,10000987,ANALYST,Beijing
-0,2012-11-01,Others,46575,0,13,54.4520,0,10000247,ANALYST,Beijing
-0,2012-06-30,FP-non GTC,26249,0,5,74.2755,0,10000641,MODELER,Hongkong
-0,2012-06-20,Auction,26262,0,11,11.9173,0,10000418,MODELER,Hongkong
-0,2012-07-24,Others,80287,0,14,49.7794,0,10000590,MODELER,Hongkong
-0,2012-08-11,FP-GTC,26262,0,11,16.2910,0,10000698,MODELER,Hongkong
-0,2013-06-27,ABIN,63861,0,-99,5.4086,0,10000810,ANALYST,Beijing
-0,2012-04-28,FP-GTC,15115,0,15,91.7724,0,10000414,MODELER,Hongkong
-0,2013-04-19,ABIN,73506,0,13,14.8212,0,10000728,ADMIN,Shanghai
-0,2012-01-25,Others,32876,0,13,23.4295,0,10000673,MODELER,Hongkong
-0,2013-11-06,ABIN,139973,3,12,41.9681,0,10000902,MODELER,Hongkong
-0,2013-03-09,Auction,61323,0,15,53.8594,0,10000323,ANALYST,Beijing
-0,2012-03-01,ABIN,60340,0,11,78.1279,0,10000947,ANALYST,Beijing
-0,2012-07-28,FP-non GTC,279,15,16,80.8961,0,10000691,MODELER,Hongkong
-0,2013-02-04,Others,24541,0,11,40.4673,0,10000727,MODELER,Hongkong
-0,2012-02-24,Auction,152801,0,13,9.8921,0,10000661,ADMIN,Shanghai
-0,2013-08-13,ABIN,156614,0,15,61.6452,0,10000734,ANALYST,Beijing
-0,2012-04-02,ABIN,63861,3,11,18.4644,0,10000446,ANALYST,Beijing
-0,2013-09-28,Others,95173,0,-99,51.2096,0,10000049,ANALYST,Beijing
-0,2013-08-13,FP-non GTC,64076,0,12,85.3952,0,10000581,ANALYST,Beijing
-0,2012-09-09,ABIN,20485,0,15,0.5979,0,10000081,ADMIN,Shanghai
-0,2012-04-26,Auction,145970,0,11,40.5874,0,10000401,ANALYST,Beijing
-0,2013-05-10,Others,26262,0,11,83.8561,0,10000545,MODELER,Hongkong
-0,2013-05-23,FP-GTC,80287,0,11,27.6123,0,10000529,ADMIN,Shanghai
-0,2012-01-08,Others,175750,0,14,45.4268,0,10000408,ANALYST,Beijing
-0,2012-07-20,ABIN,38238,0,16,44.1376,0,10000796,ADMIN,Shanghai
-0,2012-09-15,Auction,65,0,-99,97.3146,0,10000792,MODELER,Hongkong
-0,2012-10-17,ABIN,65,0,12,68.5363,0,10000569,MODELER,Hongkong
-0,2013-08-03,FP-GTC,40059,3,15,87.3892,0,10000317,ADMIN,Shanghai
-0,2013-08-28,FP-non GTC,80287,0,14,61.9829,0,10000015,ADMIN,Shanghai
-0,2012-07-21,Auction,25147,0,11,24.7662,0,10000333,MODELER,Hongkong
-0,2013-10-17,Auction,132939,0,11,11.6038,0,10000926,MODELER,Hongkong
-0,2012-09-04,Auction,44079,0,15,75.1095,0,10000435,ANALYST,Beijing
-0,2012-11-01,Auction,67698,0,5,8.8273,0,10000834,ADMIN,Shanghai
-0,2013-12-02,Auction,24541,0,15,95.2195,0,10000259,ANALYST,Beijing
-0,2012-02-06,Auction,533,0,12,66.4962,0,10000007,MODELER,Hongkong
-0,2013-12-03,FP-non GTC,99985,0,12,0.0537,0,10000244,ANALYST,Beijing
-0,2013-05-11,FP-non GTC,60606,3,12,76.6828,0,10000002,ANALYST,Beijing
-0,2012-09-18,Auction,156614,0,16,72.1912,0,10000174,ANALYST,Beijing
-0,2012-05-19,Auction,60340,0,16,42.9975,0,10000813,MODELER,Hongkong
-0,2012-04-26,FP-GTC,165888,0,14,88.3875,0,10000919,ADMIN,Shanghai
-0,2013-08-30,Others,963,0,15,6.6424,0,10000994,ADMIN,Shanghai
-0,2013-08-28,ABIN,10866,0,12,79.7295,0,10000832,ADMIN,Shanghai
-0,2012-01-16,ABIN,145970,0,11,72.3940,0,10000008,ANALYST,Beijing
-0,2013-12-23,Others,65,0,15,94.0397,0,10000812,ADMIN,Shanghai
-0,2013-09-06,FP-GTC,25147,0,11,72.9395,0,10000956,ANALYST,Beijing
-0,2012-05-07,FP-GTC,16509,0,11,9.8290,0,10000940,MODELER,Hongkong
-0,2013-09-07,Others,139973,0,11,22.9964,0,10000563,ANALYST,Beijing
-0,2012-11-17,Others,65,0,-99,62.7316,0,10000227,MODELER,Hongkong
-0,2012-05-14,ABIN,57013,0,13,19.0969,0,10000844,ANALYST,Beijing
-0,2012-06-01,FP-non GTC,30059,3,16,26.9105,0,10000516,ADMIN,Shanghai
-0,2012-11-24,Auction,75665,0,15,26.5788,0,10000717,ADMIN,Shanghai
-0,2013-10-23,FP-non GTC,75708,3,12,10.5298,0,10000238,ANALYST,Beijing
-0,2012-10-19,Auction,64076,0,11,49.0746,0,10000389,ANALYST,Beijing
-0,2012-02-17,ABIN,65,0,12,58.3004,0,10000219,MODELER,Hongkong
-0,2012-01-08,FP-GTC,15115,0,16,3.2380,0,10000435,ANALYST,Beijing
-0,2012-02-04,Others,164261,0,14,45.9304,0,10000748,ANALYST,Beijing
-0,2012-08-25,FP-GTC,156356,0,5,70.3654,0,10000864,ADMIN,Shanghai
-0,2013-04-10,FP-GTC,38238,0,5,72.9872,0,10000638,ADMIN,Shanghai
-0,2013-05-16,FP-GTC,175750,0,5,95.3008,0,10000366,ADMIN,Shanghai
-0,2012-06-27,FP-GTC,100847,0,14,64.8447,0,10000686,MODELER,Hongkong
-0,2013-03-06,Auction,139255,15,12,20.7811,0,10000261,ANALYST,Beijing
-0,2013-08-04,Auction,67698,0,14,20.1344,0,10000142,MODELER,Hongkong
-0,2013-08-15,Auction,20865,0,12,64.6842,0,10000235,ANALYST,Beijing
-0,2012-04-17,Auction,24760,0,-99,88.4159,0,10000039,ADMIN,Shanghai
-0,2013-03-14,Others,75665,0,13,36.9770,0,10000480,ANALYST,Beijing
-0,2012-12-09,Others,139973,0,15,85.1056,0,10000801,MODELER,Hongkong
-0,2012-07-02,Others,36250,0,11,71.5548,0,10000926,MODELER,Hongkong
-0,2013-08-04,FP-non GTC,31519,0,16,23.9847,0,10000680,ADMIN,Shanghai
-0,2013-02-15,FP-non GTC,80053,0,15,68.4438,0,10000487,MODELER,Hongkong
-0,2012-07-12,FP-non GTC,64076,0,5,54.5740,0,10000628,ANALYST,Beijing
-0,2012-11-07,Others,164,0,12,45.1637,0,10000846,ADMIN,Shanghai
-0,2013-09-14,FP-GTC,106340,15,15,38.1572,0,10000201,ANALYST,Beijing
-0,2013-12-19,Auction,759,0,-99,53.0086,0,10000250,ANALYST,Beijing
-0,2012-05-11,Others,16509,0,-99,68.3043,0,10000809,ADMIN,Shanghai
-0,2013-07-20,Others,45333,0,15,58.5554,0,10000981,MODELER,Hongkong
-0,2013-03-24,FP-GTC,20485,0,5,62.1012,0,10000877,ADMIN,Shanghai
-0,2013-08-09,ABIN,63861,0,5,44.1975,0,10000554,MODELER,Hongkong
-0,2013-12-04,FP-GTC,53064,0,14,29.8358,0,10000491,MODELER,Hongkong
-0,2013-07-06,ABIN,139973,0,5,26.8986,0,10000978,ANALYST,Beijing
-0,2013-04-29,FP-non GTC,67698,0,11,46.9203,0,10000148,ANALYST,Beijing
-0,2013-10-18,FP-non GTC,95173,0,14,25.5313,0,10000068,ADMIN,Shanghai
-0,2014-01-01,Auction,6762,0,13,30.6746,0,10000592,ADMIN,Shanghai
-0,2013-07-14,Auction,13836,0,16,79.4600,0,10000944,ADMIN,Shanghai
-0,2012-10-12,FP-GTC,145970,0,5,32.3728,0,10000396,ADMIN,Shanghai
-0,2013-07-28,Auction,1357,0,13,8.7896,0,10000836,ADMIN,Shanghai
-0,2013-12-06,FP-non GTC,73506,0,-99,95.4405,0,10000914,ANALYST,Beijing
-0,2012-08-01,FP-non GTC,37831,0,11,12.8673,0,10000993,MODELER,Hongkong
-0,2013-09-07,FP-non GTC,223,0,-99,16.9111,0,10000028,MODELER,Hongkong
-0,2012-12-27,FP-GTC,82494,15,15,73.5475,0,10000609,MODELER,Hongkong
-0,2012-04-07,Others,36250,0,16,7.5886,0,10000838,MODELER,Hongkong
-0,2012-10-07,FP-GTC,139973,0,12,45.3171,0,10000439,ADMIN,Shanghai
-0,2012-01-19,FP-non GTC,63861,0,16,31.1155,0,10000338,ANALYST,Beijing
-0,2013-12-16,FP-non GTC,164,0,16,41.0688,0,10000377,ANALYST,Beijing
-0,2012-03-25,ABIN,41940,0,14,8.1251,0,10000318,MODELER,Hongkong
-0,2012-04-15,FP-non GTC,65,0,-99,56.9993,0,10000697,ANALYST,Beijing
-0,2012-11-27,Auction,25147,0,14,14.5707,0,10000303,ADMIN,Shanghai
-0,2012-08-04,FP-non GTC,20213,0,11,20.6361,0,10000443,ANALYST,Beijing
-0,2013-11-15,Auction,95672,3,5,40.1888,0,10000506,ADMIN,Shanghai
-0,2013-12-26,Others,16145,0,13,34.4427,0,10000307,ANALYST,Beijing
-0,2013-11-25,Others,139973,0,16,60.8826,0,10000762,ADMIN,Shanghai
-0,2013-09-01,Others,24760,0,16,22.9159,0,10000759,ADMIN,Shanghai
-0,2012-12-10,ABIN,53064,0,14,51.2661,0,10000626,MODELER,Hongkong
-0,2013-08-24,Auction,759,0,13,48.4301,0,10000370,ADMIN,Shanghai
-0,2012-11-29,Auction,32876,0,5,86.2750,0,10000755,ANALYST,Beijing
-0,2012-06-11,Others,61323,0,13,14.7483,0,10000812,ADMIN,Shanghai
-0,2012-04-23,Others,67698,0,-99,21.2161,0,10000384,ADMIN,Shanghai
-0,2013-07-12,Others,40059,3,5,88.2983,0,10000937,ADMIN,Shanghai
-0,2012-12-27,FP-GTC,13987,0,5,29.1748,0,10000223,ADMIN,Shanghai
-0,2013-02-15,Others,113802,15,5,31.4243,0,10000672,ANALYST,Beijing
-0,2013-02-20,Auction,166013,15,15,22.9952,0,10000618,ADMIN,Shanghai
-0,2013-03-13,ABIN,73506,0,16,94.7440,0,10000476,ANALYST,Beijing
-0,2012-02-19,FP-GTC,95672,0,15,28.6221,0,10000421,ADMIN,Shanghai
-0,2013-11-30,FP-GTC,166013,15,5,92.5521,0,10000729,ADMIN,Shanghai
-0,2012-09-30,ABIN,36250,0,15,18.6346,0,10000606,ANALYST,Beijing
-0,2013-02-13,Auction,20886,0,14,24.7987,0,10000535,ANALYST,Beijing
-0,2013-11-10,FP-GTC,759,0,13,53.7935,0,10000711,ADMIN,Shanghai
-0,2013-02-10,Auction,20886,0,12,84.2953,0,10000811,MODELER,Hongkong
-0,2012-05-28,ABIN,10866,0,13,64.3564,0,10000804,ADMIN,Shanghai
-0,2013-03-19,Auction,314,0,16,36.1791,0,10000379,MODELER,Hongkong
-0,2012-01-26,FP-non GTC,132939,0,-99,31.4514,0,10000690,MODELER,Hongkong
-0,2013-02-02,FP-non GTC,20485,0,14,97.4265,0,10000642,ADMIN,Shanghai
-0,2013-07-25,Auction,139973,0,16,12.3287,0,10000972,ADMIN,Shanghai
-0,2012-09-21,Others,15115,0,11,2.7636,0,10000896,MODELER,Hongkong
-0,2012-07-26,ABIN,533,0,15,0.6745,0,10000762,ANALYST,Beijing
-0,2012-06-02,FP-non GTC,48904,0,-99,56.1505,0,10000937,ADMIN,Shanghai
-0,2012-12-11,FP-non GTC,155226,0,14,59.4547,0,10000197,ADMIN,Shanghai
-0,2012-05-30,Others,26249,0,14,18.0992,0,10000836,ADMIN,Shanghai
-0,2012-12-25,Auction,20485,0,15,23.8257,0,10000992,ADMIN,Shanghai
-0,2013-07-08,ABIN,57013,0,12,59.6550,0,10000196,ANALYST,Beijing
-0,2013-02-22,Auction,156356,0,14,36.1970,0,10000014,ANALYST,Beijing
-0,2012-03-28,ABIN,25147,0,-99,56.3283,0,10000943,ADMIN,Shanghai
-0,2012-10-09,Others,63861,0,16,9.5503,0,10000659,ADMIN,Shanghai
-0,2012-12-29,FP-non GTC,95672,0,12,57.7305,0,10000568,MODELER,Hongkong
-0,2013-06-14,Others,80053,0,13,89.8029,0,10000580,MODELER,Hongkong
-0,2012-02-14,Others,67698,0,16,73.0734,0,10000857,MODELER,Hongkong
-0,2013-05-14,FP-non GTC,62179,0,5,58.7369,0,10000091,ANALYST,Beijing
-0,2013-06-16,FP-GTC,1504,0,5,7.2913,0,10000054,ADMIN,Shanghai
-0,2013-07-30,FP-non GTC,31673,0,-99,13.2961,0,10000654,MODELER,Hongkong
-0,2013-05-22,ABIN,130,0,-99,1.3005,0,10000925,ADMIN,Shanghai
-0,2012-03-06,FP-GTC,35570,100,15,45.7240,0,10000773,MODELER,Hongkong
-0,2012-07-20,Auction,15868,0,15,88.4248,0,10000965,ADMIN,Shanghai
-0,2013-10-02,Auction,38238,0,15,34.7237,0,10000987,ANALYST,Beijing
-0,2012-11-06,Others,67698,0,-99,3.3750,0,10000902,ADMIN,Shanghai
-0,2012-01-11,FP-GTC,62179,0,11,77.9520,0,10000540,ADMIN,Shanghai
-0,2012-09-23,FP-GTC,64076,0,12,57.1896,0,10000772,ANALYST,Beijing
-0,2012-03-03,ABIN,103178,15,11,26.3886,0,10000000,MODELER,Hongkong
-0,2012-05-26,FP-GTC,48027,0,16,87.2722,0,10000836,ANALYST,Beijing
-0,2012-05-06,ABIN,38238,0,16,34.7669,0,10000942,MODELER,Hongkong
-0,2014-01-01,Auction,170302,15,11,62.2724,0,10000988,ADMIN,Shanghai
-0,2012-06-19,FP-GTC,37831,0,13,78.1533,0,10000362,ANALYST,Beijing
-0,2012-01-12,ABIN,48904,0,-99,80.2518,0,10000266,ANALYST,Beijing
-0,2013-06-24,ABIN,10866,0,12,87.3794,0,10000655,ANALYST,Beijing
-0,2013-07-17,Others,1349,0,12,40.6979,0,10000754,ADMIN,Shanghai
-0,2013-06-14,Auction,139973,0,14,54.9050,0,10000105,ANALYST,Beijing
-0,2012-06-18,ABIN,15868,0,-99,69.2751,0,10000988,ADMIN,Shanghai
-0,2012-09-07,Auction,1349,0,11,24.7687,0,10000323,ANALYST,Beijing
-0,2012-02-01,ABIN,61323,0,-99,72.0754,0,10000321,ANALYST,Beijing
-0,2013-07-28,ABIN,152801,0,11,71.8684,0,10000701,ANALYST,Beijing
-0,2013-04-16,Others,60340,0,-99,9.8364,0,10000952,ADMIN,Shanghai
-0,2012-01-06,ABIN,80053,0,12,45.9154,0,10000726,ANALYST,Beijing
-0,2012-02-07,Auction,223,0,12,90.7522,0,10000949,ADMIN,Shanghai
-0,2012-09-15,Others,50677,0,5,50.2863,0,10000285,MODELER,Hongkong
-0,2013-04-01,Auction,75665,0,12,40.7265,0,10000498,MODELER,Hongkong
-0,2012-11-09,ABIN,95672,0,12,85.7492,0,10000180,ADMIN,Shanghai
-0,2013-09-22,FP-GTC,16145,0,16,37.4930,0,10000453,ADMIN,Shanghai
-0,2012-11-02,Auction,73506,0,5,61.7567,0,10000361,ANALYST,Beijing
-0,2013-10-27,Auction,963,0,-99,26.4725,0,10000909,MODELER,Hongkong
-0,2012-01-13,FP-GTC,10866,0,16,84.3734,0,10000539,ANALYST,Beijing
-0,2012-05-26,FP-non GTC,152801,0,5,77.1831,0,10000961,MODELER,Hongkong
-0,2013-06-04,ABIN,57013,0,-99,59.7825,0,10000542,ADMIN,Shanghai
-0,2012-11-26,FP-GTC,9426,3,5,83.8080,0,10000847,ADMIN,Shanghai
-0,2013-12-11,ABIN,67698,0,14,67.3561,0,10000409,ANALYST,Beijing
-0,2013-06-01,ABIN,95173,0,13,50.4721,0,10000245,ADMIN,Shanghai
-0,2012-07-25,FP-GTC,175750,0,16,62.5123,0,10000399,ANALYST,Beijing
-0,2012-01-22,FP-GTC,31673,0,13,8.1462,0,10000125,ANALYST,Beijing
-0,2012-01-17,Auction,63861,0,15,86.7921,0,10000067,ADMIN,Shanghai
-0,2012-07-06,Others,20886,0,-99,91.8578,0,10000349,ANALYST,Beijing
-0,2012-02-26,FP-non GTC,216,0,13,25.5255,0,10000465,MODELER,Hongkong
-0,2013-10-05,Others,65,0,11,50.8591,0,10000718,MODELER,Hongkong
-0,2012-12-30,FP-non GTC,87118,0,11,81.3002,0,10000122,ADMIN,Shanghai
-0,2013-08-20,ABIN,130,0,13,61.5051,0,10000685,MODELER,Hongkong
-0,2012-11-07,ABIN,57013,0,15,87.1409,0,10000157,ANALYST,Beijing
-0,2012-11-26,Others,75665,0,16,85.4010,0,10000935,MODELER,Hongkong
-0,2013-12-17,FP-GTC,63861,0,14,45.7096,0,10000650,MODELER,Hongkong
-0,2012-08-12,FP-non GTC,20485,0,-99,44.4235,0,10000954,ANALYST,Beijing
-0,2012-01-17,Auction,314,0,12,75.8335,0,10000514,ADMIN,Shanghai
-0,2013-01-24,ABIN,2635,0,12,10.6521,0,10000839,ADMIN,Shanghai
-0,2012-02-05,ABIN,3838,0,12,76.2544,0,10000344,ANALYST,Beijing
-0,2013-05-13,FP-GTC,106246,0,14,25.5924,0,10000291,ANALYST,Beijing
-0,2013-03-16,Auction,82494,15,5,15.6450,0,10000366,ADMIN,Shanghai
-0,2012-01-06,Auction,65,0,11,9.8382,0,10000415,MODELER,Hongkong
-0,2012-08-10,ABIN,24541,0,-99,21.1252,0,10000872,ADMIN,Shanghai
-0,2012-06-01,Others,106246,0,11,51.6742,0,10000000,MODELER,Hongkong
-0,2013-05-10,Others,63861,0,-99,69.1514,0,10000869,MODELER,Hongkong
-0,2013-04-04,FP-non GTC,73506,0,13,7.8706,0,10000986,ADMIN,Shanghai
-0,2013-10-23,ABIN,43972,100,-99,31.5134,0,10000011,ADMIN,Shanghai
-0,2013-05-10,Auction,80053,0,-99,2.8786,0,10000544,ANALYST,Beijing
-0,2012-03-26,FP-non GTC,80053,0,13,59.3087,0,10000881,ANALYST,Beijing
-0,2012-07-24,Auction,20485,0,-99,49.9084,0,10000757,ADMIN,Shanghai
-0,2013-04-10,ABIN,66767,15,5,48.4303,0,10000471,ANALYST,Beijing
-0,2013-07-09,ABIN,13987,0,12,82.6598,0,10000495,MODELER,Hongkong
-0,2012-12-25,ABIN,145970,0,5,6.4088,0,10000723,ANALYST,Beijing
-0,2013-11-14,FP-non GTC,113593,15,15,10.9465,0,10000701,ANALYST,Beijing
-0,2013-08-17,Auction,26249,0,12,90.2925,0,10000684,MODELER,Hongkong
-0,2013-03-28,Auction,53064,0,13,1.5558,0,10000884,ANALYST,Beijing
-0,2013-05-04,ABIN,88750,0,15,41.8885,0,10000078,MODELER,Hongkong
-0,2013-07-20,Others,60340,0,-99,79.8564,0,10000590,ADMIN,Shanghai
-0,2012-12-10,ABIN,1504,0,13,22.2111,0,10000603,ANALYST,Beijing
-0,2012-01-18,FP-non GTC,1349,0,-99,40.5209,0,10000684,ADMIN,Shanghai
-0,2013-01-21,FP-non GTC,25147,0,13,47.2094,0,10000676,MODELER,Hongkong
-0,2013-10-18,FP-non GTC,164261,0,5,71.2879,0,10000998,ADMIN,Shanghai
-0,2012-08-18,Others,61323,0,15,59.1738,0,10000705,MODELER,Hongkong
-0,2012-01-28,ABIN,1357,0,11,31.3101,0,10000131,ANALYST,Beijing
-0,2013-12-25,Others,94847,0,13,90.8027,0,10000674,ANALYST,Beijing
-0,2013-12-26,Others,156614,0,5,14.9093,0,10000123,MODELER,Hongkong
-0,2012-06-19,Others,43398,0,13,85.5022,0,10000874,MODELER,Hongkong
-0,2012-12-12,FP-non GTC,145970,0,16,71.8714,0,10000686,ANALYST,Beijing
-0,2012-02-11,Others,24760,0,14,49.0051,0,10000611,ANALYST,Beijing
-0,2013-06-02,Others,759,0,13,56.3362,0,10000185,ADMIN,Shanghai
-0,2012-09-30,Auctio
<TRUNCATED>
[2/8] kylin git commit: KYLIN-2070 add seg status info
Posted by li...@apache.org.
KYLIN-2070 add seg status info
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/5aa0ae31
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/5aa0ae31
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/5aa0ae31
Branch: refs/heads/KYLIN-1971
Commit: 5aa0ae318ea740eefbacbcd5bfc963b3ca2aace9
Parents: 4f76e16
Author: shaofengshi <sh...@apache.org>
Authored: Fri Oct 21 11:48:59 2016 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Fri Oct 21 11:48:59 2016 +0800
----------------------------------------------------------------------
.../org/apache/kylin/rest/controller/CubeController.java | 1 +
.../java/org/apache/kylin/rest/response/HBaseResponse.java | 9 +++++++++
2 files changed, 10 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/5aa0ae31/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
----------------------------------------------------------------------
diff --git a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
index a3f9ec0..e1ee85d 100644
--- a/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
+++ b/server-base/src/main/java/org/apache/kylin/rest/controller/CubeController.java
@@ -528,6 +528,7 @@ public class CubeController extends BasicController {
hr.setDateRangeStart(segment.getDateRangeStart());
hr.setDateRangeEnd(segment.getDateRangeEnd());
hr.setSegmentName(segment.getName());
+ hr.setSegmentStatus(segment.getStatus().toString());
hr.setSourceCount(segment.getInputRecords());
if (segment.isSourceOffsetsOn()) {
hr.setSourceOffsetStart(segment.getSourceOffsetStart());
http://git-wip-us.apache.org/repos/asf/kylin/blob/5aa0ae31/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
----------------------------------------------------------------------
diff --git a/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java b/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
index 985596d..f68c096 100644
--- a/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
+++ b/server-base/src/main/java/org/apache/kylin/rest/response/HBaseResponse.java
@@ -23,6 +23,7 @@ import java.io.Serializable;
public class HBaseResponse implements Serializable {
private static final long serialVersionUID = 7263557115683263492L;
private String segmentName;
+ private String segmentStatus;
private String tableName;
private long tableSize;
private int regionCount;
@@ -118,6 +119,14 @@ public class HBaseResponse implements Serializable {
this.segmentName = segmentName;
}
+ public String getSegmentStatus() {
+ return segmentStatus;
+ }
+
+ public void setSegmentStatus(String segmentStatus) {
+ this.segmentStatus = segmentStatus;
+ }
+
public long getSourceOffsetStart() {
return sourceOffsetStart;
}
[6/8] kylin git commit: KYLIN-1971 refactor ModelDesc to use TableRef
Posted by li...@apache.org.
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/sample_cube/template/table/DEFAULT.KYLIN_COUNTRY.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/template/table/DEFAULT.KYLIN_COUNTRY.json b/examples/sample_cube/template/table/DEFAULT.KYLIN_COUNTRY.json
new file mode 100644
index 0000000..8d38810
--- /dev/null
+++ b/examples/sample_cube/template/table/DEFAULT.KYLIN_COUNTRY.json
@@ -0,0 +1,24 @@
+{
+ "uuid" : "e286e39e-40d7-44c2-8fa2-41b365632882",
+
+ "name" : "KYLIN_COUNTRY",
+ "columns" : [ {
+ "id" : "1",
+ "name" : "COUNTRY",
+ "datatype" : "string"
+ }, {
+ "id" : "2",
+ "name" : "LATITUDE",
+ "datatype" : "double"
+ }, {
+ "id" : "3",
+ "name" : "LONGITUDE",
+ "datatype" : "double"
+ }, {
+ "id" : "4",
+ "name" : "NAME",
+ "datatype" : "string"
+ } ],
+ "database" : "DEFAULT",
+ "last_modified" : 0
+}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json b/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
index 2bccbeb..fbeafb3 100644
--- a/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
+++ b/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
@@ -38,15 +38,23 @@
"id" : "9",
"name" : "SELLER_ID",
"datatype" : "bigint"
- }, {
- "id" : "10",
- "name" : "USER_ID",
- "datatype" : "string"
- }, {
- "id" : "11",
- "name" : "REGION",
- "datatype" : "string"
+ }, {
+ "id" : "10",
+ "name" : "BUYER_COUNTRY",
+ "datatype" : "string"
+ }, {
+ "id" : "11",
+ "name" : "SELLER_COUNTRY",
+ "datatype" : "string"
+ }, {
+ "id" : "12",
+ "name" : "USER_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "13",
+ "name" : "REGION",
+ "datatype" : "string"
} ],
"database" : "DEFAULT",
"last_modified" : 0
-}
+}
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_model_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_model_desc.json b/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_model_desc.json
new file mode 100644
index 0000000..b06a217
--- /dev/null
+++ b/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_model_desc.json
@@ -0,0 +1,161 @@
+{
+ "uuid": "ac0f4ee2-1dcb-4b07-a38e-4c298563e0e3",
+ "name": "test_kylin_snowflake_model_desc",
+ "lookups": [
+ {
+ "table": "EDW.TEST_CAL_DT",
+ "join": {
+ "type": "left",
+ "primary_key": [
+ "CAL_DT"
+ ],
+ "foreign_key": [
+ "CAL_DT"
+ ]
+ }
+ },
+ {
+ "table": "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "join": {
+ "type": "left",
+ "primary_key": [
+ "LEAF_CATEG_ID",
+ "SITE_ID"
+ ],
+ "foreign_key": [
+ "LEAF_CATEG_ID",
+ "LSTG_SITE_ID"
+ ]
+ }
+ },
+ {
+ "table": "EDW.TEST_SITES",
+ "join": {
+ "type": "left",
+ "primary_key": [
+ "SITE_ID"
+ ],
+ "foreign_key": [
+ "LSTG_SITE_ID"
+ ]
+ }
+ },
+ {
+ "table": "EDW.TEST_SELLER_TYPE_DIM",
+ "join": {
+ "type": "left",
+ "primary_key": [
+ "SELLER_TYPE_CD"
+ ],
+ "foreign_key": [
+ "SLR_SEGMENT_CD"
+ ]
+ }
+ },
+ {
+ "table": "DEFAULT.TEST_KYLIN_COUNTRY",
+ "alias": "BUYER_COUNTRY",
+ "join": {
+ "type": "left",
+ "primary_key": [
+ "COUNTRY"
+ ],
+ "foreign_key": [
+ "BUYER_COUNTRY"
+ ]
+ }
+ },
+ {
+ "table": "DEFAULT.TEST_KYLIN_COUNTRY",
+ "alias": "SELLER_COUNTRY",
+ "join": {
+ "type": "left",
+ "primary_key": [
+ "COUNTRY"
+ ],
+ "foreign_key": [
+ "SELLER_COUNTRY"
+ ]
+ }
+ }
+ ],
+ "dimensions": [
+ {
+ "table": "default.test_kylin_fact",
+ "columns": [
+ "lstg_format_name",
+ "LSTG_SITE_ID",
+ "SLR_SEGMENT_CD",
+ "TRANS_ID",
+ "CAL_DT",
+ "LEAF_CATEG_ID",
+ "SELLER_ID",
+ "BUYER_COUNTRY",
+ "SELLER_COUNTRY"
+ ]
+ },
+ {
+ "table": "default.test_category_groupings",
+ "columns": [
+ "leaf_categ_id",
+ "site_id",
+ "USER_DEFINED_FIELD1",
+ "USER_DEFINED_FIELD3",
+ "UPD_DATE",
+ "UPD_USER",
+ "meta_categ_name",
+ "categ_lvl2_name",
+ "categ_lvl3_name"
+ ]
+ },
+ {
+ "table": "edw.test_sites",
+ "columns": [
+ "site_id",
+ "site_name",
+ "cre_user"
+ ]
+ },
+ {
+ "table": "edw.test_seller_type_dim",
+ "columns": [
+ "seller_type_cd",
+ "seller_type_desc"
+ ]
+ },
+ {
+ "table": "edw.test_cal_dt",
+ "columns": [
+ "cal_dt",
+ "week_beg_dt"
+ ]
+ },
+ {
+ "table": "BUYER_COUNTRY",
+ "columns": [
+ "country",
+ "name"
+ ]
+ },
+ {
+ "table": "SELLER_COUNTRY",
+ "columns": [
+ "country",
+ "name"
+ ]
+ }
+ ],
+ "metrics": [
+ "PRICE",
+ "ITEM_COUNT",
+ "SELLER_ID"
+ ],
+ "last_modified": 1422435345352,
+ "fact_table": "DEFAULT.TEST_KYLIN_FACT",
+ "filter_condition": null,
+ "partition_desc": {
+ "partition_date_column": "DEFAULT.TEST_KYLIN_FACT.cal_dt",
+ "partition_date_start": 0,
+ "partition_type": "APPEND"
+ }
+}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json b/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json
new file mode 100644
index 0000000..95b34c2
--- /dev/null
+++ b/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json
@@ -0,0 +1,24 @@
+{
+ "uuid" : "e286e39e-40d7-44c2-8fa2-41b365632882",
+
+ "name" : "TEST_KYLIN_COUNTRY",
+ "columns" : [ {
+ "id" : "1",
+ "name" : "COUNTRY",
+ "datatype" : "string"
+ }, {
+ "id" : "2",
+ "name" : "LATITUDE",
+ "datatype" : "double"
+ }, {
+ "id" : "3",
+ "name" : "LONGITUDE",
+ "datatype" : "double"
+ }, {
+ "id" : "4",
+ "name" : "NAME",
+ "datatype" : "string"
+ } ],
+ "database" : "DEFAULT",
+ "last_modified" : 0
+}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/f1f69d44/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_FACT.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_FACT.json b/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_FACT.json
index ee21ea0..3e65edd 100644
--- a/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_FACT.json
+++ b/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_FACT.json
@@ -38,6 +38,14 @@
"id" : "9",
"name" : "SELLER_ID",
"datatype" : "bigint"
+ }, {
+ "id" : "10",
+ "name" : "BUYER_COUNTRY",
+ "datatype" : "string"
+ }, {
+ "id" : "11",
+ "name" : "SELLER_COUNTRY",
+ "datatype" : "string"
} ],
"database" : "DEFAULT",
"last_modified" : 0
[3/8] kylin git commit: KYLIN-2086 Still report error when there is
more than 12 dimensions in one agg group
Posted by li...@apache.org.
KYLIN-2086 Still report error when there is more than 12 dimensions in one agg group
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/325803d2
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/325803d2
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/325803d2
Branch: refs/heads/KYLIN-1971
Commit: 325803d2ff47f8b2b7e9e326cc7d1781fa9877d5
Parents: 5aa0ae3
Author: shaofengshi <sh...@apache.org>
Authored: Fri Oct 21 14:28:49 2016 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Fri Oct 21 14:28:49 2016 +0800
----------------------------------------------------------------------
.../validation/rule/AggregationGroupRule.java | 34 +++++++-------------
.../kylin/cube/AggregationGroupRuleTest.java | 8 ++---
2 files changed, 16 insertions(+), 26 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/325803d2/core-cube/src/main/java/org/apache/kylin/cube/model/validation/rule/AggregationGroupRule.java
----------------------------------------------------------------------
diff --git a/core-cube/src/main/java/org/apache/kylin/cube/model/validation/rule/AggregationGroupRule.java b/core-cube/src/main/java/org/apache/kylin/cube/model/validation/rule/AggregationGroupRule.java
index defe898..7b90782 100644
--- a/core-cube/src/main/java/org/apache/kylin/cube/model/validation/rule/AggregationGroupRule.java
+++ b/core-cube/src/main/java/org/apache/kylin/cube/model/validation/rule/AggregationGroupRule.java
@@ -23,7 +23,6 @@ import java.util.Set;
import java.util.TreeSet;
import org.apache.commons.collections.CollectionUtils;
-import org.apache.kylin.common.KylinConfig;
import org.apache.kylin.cube.model.AggregationGroup;
import org.apache.kylin.cube.model.CubeDesc;
import org.apache.kylin.cube.model.validation.IValidatorRule;
@@ -41,16 +40,7 @@ public class AggregationGroupRule implements IValidatorRule<CubeDesc> {
inner(cube, context);
}
- private int count(String[][] input) {
- if (input == null) {
- return 0;
- } else {
- return input.length;
- }
- }
-
private void inner(CubeDesc cube, ValidateContext context) {
- int maxSize = getMaxAgrGroupSize();
int index = 0;
for (AggregationGroup agg : cube.getAggregationGroups()) {
@@ -64,6 +54,7 @@ public class AggregationGroupRule implements IValidatorRule<CubeDesc> {
continue;
}
+ int combination = 1;
Set<String> includeDims = new TreeSet<>(String.CASE_INSENSITIVE_ORDER);
if (agg.getIncludes() != null) {
for (String include : agg.getIncludes()) {
@@ -84,6 +75,7 @@ public class AggregationGroupRule implements IValidatorRule<CubeDesc> {
for (String s : ss) {
hierarchyDims.add(s);
}
+ combination = combination * (ss.length + 1);
}
}
@@ -93,6 +85,7 @@ public class AggregationGroupRule implements IValidatorRule<CubeDesc> {
for (String s : ss) {
jointDims.add(s);
}
+ combination = combination * 2;
}
}
@@ -107,15 +100,7 @@ public class AggregationGroupRule implements IValidatorRule<CubeDesc> {
normalDims.removeAll(hierarchyDims);
normalDims.removeAll(jointDims);
- int normalDimSize = normalDims.size();
- int hierarchySize = count(agg.getSelectRule().hierarchy_dims);
- int jointSize = count(agg.getSelectRule().joint_dims);
- int mandatorySize = mandatoryDims.size() > 0 ? 1 : 0;
-
- if (mandatorySize + normalDimSize + hierarchySize + jointSize > maxSize) {
- context.addResult(ResultLevel.ERROR, "Aggregation group " + index + " has too many dimensions");
- continue;
- }
+ combination = combination * (1 << normalDims.size());
if (CollectionUtils.containsAny(mandatoryDims, hierarchyDims)) {
context.addResult(ResultLevel.ERROR, "Aggregation group " + index + " mandatory dims overlap with hierarchy dims");
@@ -169,12 +154,17 @@ public class AggregationGroupRule implements IValidatorRule<CubeDesc> {
}
}
+ if (combination > getMaxCombinations(cube)) {
+ String msg = "Aggregation group " + index + " has too many combinations, use 'mandatory'/'hierarchy'/'joint' to optimize; or update 'kylin.cube.aggrgroup.max.combination' to a bigger value.";
+ context.addResult(ResultLevel.ERROR, msg);
+ continue;
+ }
+
index++;
}
}
- @SuppressWarnings("deprecation")
- protected int getMaxAgrGroupSize() {
- return KylinConfig.getInstanceFromEnv().getCubeAggrGroupMaxSize();
+ protected int getMaxCombinations(CubeDesc cubeDesc) {
+ return cubeDesc.getConfig().getCubeAggrGroupMaxCombination();
}
}
http://git-wip-us.apache.org/repos/asf/kylin/blob/325803d2/core-cube/src/test/java/org/apache/kylin/cube/AggregationGroupRuleTest.java
----------------------------------------------------------------------
diff --git a/core-cube/src/test/java/org/apache/kylin/cube/AggregationGroupRuleTest.java b/core-cube/src/test/java/org/apache/kylin/cube/AggregationGroupRuleTest.java
index 6c3d544..a06ce1b 100644
--- a/core-cube/src/test/java/org/apache/kylin/cube/AggregationGroupRuleTest.java
+++ b/core-cube/src/test/java/org/apache/kylin/cube/AggregationGroupRuleTest.java
@@ -53,7 +53,7 @@ public class AggregationGroupRuleTest {
public void testGoodBecomeBadDesc() throws IOException {
AggregationGroupRule rule = new AggregationGroupRule() {
@Override
- protected int getMaxAgrGroupSize() {
+ protected int getMaxCombinations(CubeDesc cubeDesc) {
return 2;
}
};
@@ -65,7 +65,7 @@ public class AggregationGroupRuleTest {
rule.validate(desc, vContext);
vContext.print(System.out);
assertTrue(vContext.getResults().length > 0);
- assertEquals("Aggregation group 0 has too many dimensions", (vContext.getResults()[0].getMessage()));
+ assertEquals("Aggregation group 0 has too many combinations, use 'mandatory'/'hierarchy'/'joint' to optimize; or update 'kylin.cube.aggrgroup.max.combination' to a bigger value.", (vContext.getResults()[0].getMessage()));
}
}
@@ -118,8 +118,8 @@ public class AggregationGroupRuleTest {
public AggregationGroupRule getAggregationGroupRule() {
AggregationGroupRule rule = new AggregationGroupRule() {
@Override
- protected int getMaxAgrGroupSize() {
- return 20;
+ protected int getMaxCombinations(CubeDesc cubeDesc) {
+ return 4096;
}
};