Request perm to edit wiki

2013-06-19 Thread FangKun Cao
Issue HIVE-3682 add a new feature that user could define custom field separators and add serde / output formats support for writing out . But the usage has not been updated in the following wiki: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Writingdataint

Review Request: HIVE-4064, Handle db qualified names consistently across all HiveQL statements

2013-06-09 Thread fangkun cao
/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java 1489269 http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g 1489269 Diff: https://reviews.apache.org/r/11755/diff/ Testing --- Thanks, fangkun cao

Review Request: HIVE-3589, show partition/show tblproperties command should accept database name

2013-06-08 Thread fangkun cao
=11 ds=2008-04-09/hr=12 ds=2008-05-11/hr=12 ds=2008-12-31/hr=11 ds=2008-12-31/hr=12 Time taken: 0.194 seconds, Fetched: 8 row(s) Thanks, fangkun cao

Re: Review Request: when writing data into filesystem from queries , the output files could contain a line of column names

2013-06-06 Thread fangkun cao
/repos/asf/hive/trunk/ql/src/test/results/clientpositive/insert_overwrite_local_directory_2.q.out PRE-CREATION Diff: https://reviews.apache.org/r/10474/diff/ Testing --- Thanks, fangkun cao

Re: error in running the hive test cases

2013-06-05 Thread FangKun Cao
check if hadoop-test-*.jar is in the classpath 2013/6/4 ur lops > Hi, > When I run the hive test case, I keep getting the following error: > [echo] Project: serde > [javac] Compiling 36 source files to > /home/john/dev/hive-0.9.0-Intel/src/build/serde/test/classes > [javac] TestAv

Review Request: HIVE-4659 while sql contains \t ? 'desc formatted view_name' and 'show create table view_name' statements will generate Incomplete results

2013-06-05 Thread fangkun cao
shots --- Example View https://reviews.apache.org/r/11652/s/27/ Thanks, fangkun cao

Review Request: HIVE-3393 brought in Jackson library, and these four jars should be packed into hive-exec.jar

2013-05-15 Thread fangkun cao
/browse/HIVE-4562 This addresses bug HIVE-4562. https://issues.apache.org/jira/browse/HIVE-4562 Diffs - http://svn.apache.org/repos/asf/hive/trunk/ql/build.xml 1482225 Diff: https://reviews.apache.org/r/11173/diff/ Testing --- Thanks, fangkun cao

Re: Review Request: when writing data into filesystem from queries , the output files could contain a line of column names

2013-05-07 Thread fangkun cao
/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 1480161 http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadFileDesc.java 1480161 Diff: https://reviews.apache.org/r/10474/diff/ Testing --- Thanks, fangkun cao

Re: Review Request: enhance TRUNCATE syntex to drop data of external table

2013-04-18 Thread fangkun cao
(ds='2008-04-09'); -- trucate EXTERNAL table TRUNCATE TABLE external1 PARTITION (ds='2008-04-08') FORCE; select * from external1 where ds='2008-04-08'; select * from external1 where ds='2008-04-09'; TRUNCATE TABLE external1 FORCE; select * from external1; Thanks, fangkun cao

Review Request: enhance TRUNCATE syntex to drop data of external table

2013-04-17 Thread fangkun cao
ernal1 PARTITION (ds='2008-04-08') FORCE; select * from external1 where ds='2008-04-08'; select * from external1 where ds='2008-04-09'; TRUNCATE TABLE external1 FORCE; select * from external1; Thanks, fangkun cao

Re: Review Request: when writing data into filesystem from queries , the output files could contain a line of column names

2013-04-15 Thread fangkun cao
/hive/ql/parse/SemanticAnalyzer.java 1467854 http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/LoadFileDesc.java 1467854 Diff: https://reviews.apache.org/r/10474/diff/ Testing --- Thanks, fangkun cao

Review Request: when writing data into filesystem from queries , the output files could contain a line of column names

2013-04-15 Thread fangkun cao
/src/java/org/apache/hadoop/hive/ql/plan/LoadFileDesc.java 1467854 Diff: https://reviews.apache.org/r/10474/diff/ Testing --- Thanks, fangkun cao

Review Request: For partitioned table , if where statement is 'const string equals const string', the query will throw MismatchedTokenException

2013-04-07 Thread fangkun cao
/test/queries/clientpositive/const_filter.q PRE-CREATION Diff: https://reviews.apache.org/r/10334/diff/ Testing --- Thanks, fangkun cao

Review Request: HIVE-4032:Inserting data into Hive table from a query, when the query is a partitioned table and select * , will generate a SemanticException

2013-04-01 Thread fangkun cao
obalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.zr_test [2013-04-02 12:33:15]: Time taken: 3.001 seconds Thanks, fangkun cao

Re: Review Request: when output hive table to file, users should could have a separator of their own choice

2013-03-25 Thread fangkun cao
org/repos/asf/hive/trunk/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1.q.out PRE-CREATION Diff: https://reviews.apache.org/r/10115/diff/ Testing --- Thanks, fangkun cao

Re: Review Request: when output hive table to file, users should could have a separator of their own choice

2013-03-25 Thread fangkun cao
ttp://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java 1460536 http://svn.apache.org/repos/asf/hive/trunk/ql/src/test/queries/clientpositive/insert_overwrite_local_directory_1.q PRE-CREATION http://svn.apache.org/repos/asf/hive/trunk/ql/src/test/results/clientpositive/insert_overwrite_local_directory_1.q.out PRE-CREATION Diff: https://reviews.apache.org/r/10115/diff/ Testing --- Thanks, fangkun cao

Review Request: when output hive table to file, users should could have a separator of their own choice

2013-03-25 Thread fangkun cao
esc.java 1460536 http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java 1460536 Diff: https://reviews.apache.org/r/10115/diff/ Testing --- Thanks, fangkun cao

Re: [jira] [Commented] (HIVE-3999) Mysql metastore upgrade script will end up with different schema than the full schema load

2013-02-17 Thread FangKun Cao
Hi Jarek Jarcec Cecho, I agree with you now. Your solution is the most suitable way. 2013/2/18 Jarek Jarcec Cecho (JIRA) > > [ > https://issues.apache.org/jira/browse/HIVE-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13580457#comment-13580457