You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ja...@apache.org on 2017/06/27 14:08:09 UTC
[03/12] carbondata git commit: Update hive-guide.md
Update hive-guide.md
Correct some invalid steps.
Project: http://git-wip-us.apache.org/repos/asf/carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/carbondata/commit/22b34773
Tree: http://git-wip-us.apache.org/repos/asf/carbondata/tree/22b34773
Diff: http://git-wip-us.apache.org/repos/asf/carbondata/diff/22b34773
Branch: refs/heads/encoding_override
Commit: 22b34773f1fc9176718780b6095f80f1647b375b
Parents: 4a6f57e
Author: Liang Chen <ch...@apache.org>
Authored: Sat Jun 24 17:24:08 2017 +0800
Committer: GitHub <no...@github.com>
Committed: Sat Jun 24 17:24:08 2017 +0800
----------------------------------------------------------------------
integration/hive/hive-guide.md | 9 +++++----
1 file changed, 5 insertions(+), 4 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/carbondata/blob/22b34773/integration/hive/hive-guide.md
----------------------------------------------------------------------
diff --git a/integration/hive/hive-guide.md b/integration/hive/hive-guide.md
index 4d3c740..9b72443 100644
--- a/integration/hive/hive-guide.md
+++ b/integration/hive/hive-guide.md
@@ -77,19 +77,20 @@ copy snappy-java-xxx.jar from "./<SPARK_HOME>/jars/" to "./Library/Java/Extensio
export HADOOP_OPTS="-Dorg.xerial.snappy.lib.path=/Library/Java/Extensions -Dorg.xerial.snappy.lib.name=libsnappyjava.jnilib -Dorg.xerial.snappy.tempdir=/Users/apple/DEMO/tmp"
```
-### Alter schema in Hive
+### Start hive client
$HIVE_HOME/bin/hive
+### Initialize schema in hive
```
+create table in hive:
+CREATE TABLE IF NOT EXISTS hive_carbon(id int, name string, scale decimal, country string, salary double) row format delimited fields terminated by ',' stored as textfile;
+
alter table hive_carbon set FILEFORMAT
INPUTFORMAT "org.apache.carbondata.hive.MapredCarbonInputFormat"
OUTPUTFORMAT "org.apache.carbondata.hive.MapredCarbonOutputFormat"
SERDE "org.apache.carbondata.hive.CarbonHiveSerDe";
alter table hive_carbon set LOCATION '<hdfs store path>/carbon/store/default/hive_carbon';
-alter table hive_carbon change col id INT;
-alter table hive_carbon add columns(name string, scale decimal(10, 2), country string, salary double);
-
```
### Query data from hive table