[ https://issues.apache.org/jira/browse/HIVE-5221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13767434#comment-13767434 ]
Hive QA commented on HIVE-5221: ------------------------------- {color:red}Overall{color}: -1 no tests executed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12602980/HIVE-5221.1.patch Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/731/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/731/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Tests failed with: NonZeroExitCodeException: Command 'bash /data/hive-ptest/working/scratch/source-prep.sh' failed with exit status 1 and output '+ [[ -n '' ]] + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m -Dhttp.proxyHost=localhost -Dhttp.proxyPort=3128' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m -Dhttp.proxyHost=localhost -Dhttp.proxyPort=3128' + cd /data/hive-ptest/working/ + tee /data/hive-ptest/logs/PreCommit-HIVE-Build-731/source-prep.txt + mkdir -p maven ivy + [[ svn = \s\v\n ]] + [[ -n '' ]] + [[ -d apache-svn-trunk-source ]] + [[ ! -d apache-svn-trunk-source/.svn ]] + [[ ! -d apache-svn-trunk-source ]] + cd apache-svn-trunk-source + svn revert -R . Reverted 'data/files/datatypes.txt' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyFactory.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/lazy/objectinspector/primitive/LazyPrimitiveObjectInspectorFactory.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/lazybinary/LazyBinaryUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/lazybinary/LazyBinarySerDe.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/lazybinary/LazyBinaryFactory.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoFactory.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/ParameterizedPrimitiveTypeUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfo.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/TypeInfoUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/ObjectInspectorConverters.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/PrimitiveObjectInspector.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/ObjectInspectorUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorConverter.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorFactory.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/SerDeUtils.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/io/DoubleWritable.java' Reverted 'serde/src/java/org/apache/hadoop/hive/serde2/avro/AvroObjectInspectorGenerator.java' Reverted 'serde/src/gen/thrift/gen-py/org_apache_hadoop_hive_serde/constants.py' Reverted 'serde/src/gen/thrift/gen-cpp/serde_constants.cpp' Reverted 'serde/src/gen/thrift/gen-cpp/serde_constants.h' Reverted 'serde/src/gen/thrift/gen-rb/serde_constants.rb' Reverted 'serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/test/ThriftTestObj.java' Reverted 'serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/serdeConstants.java' Reverted 'serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/Complex.java' Reverted 'serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde2/thrift/test/MegaStruct.java' Reverted 'serde/src/gen/thrift/gen-php/org/apache/hadoop/hive/serde/Types.php' Reverted 'serde/if/serde.thrift' Reverted 'ql/src/test/org/apache/hadoop/hive/ql/exec/TestFunctionRegistry.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/plan/CreateTableDesc.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeConstantDesc.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/ParseUtils.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/GenericUDFEncode.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFStringToMap.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFComputeStats.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFUtils.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFToDate.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFConcatWS.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFBaseCompare.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFReflect2.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/udf/UDFToString.java' ++ awk '{print $2}' ++ egrep -v '^X|^Performing status on external' ++ svn status --no-ignore + rm -rf build data/files/vc1.txt hcatalog/build hcatalog/core/build hcatalog/storage-handlers/hbase/build hcatalog/server-extensions/build hcatalog/webhcat/svr/build hcatalog/webhcat/java-client/build hcatalog/hcatalog-pig-adapter/build common/src/gen common/src/test/org/apache/hadoop/hive/common/type common/src/java/org/apache/hadoop/hive/common/type/HiveVarchar.java common/src/java/org/apache/hadoop/hive/common/type/HiveBaseChar.java serde/src/test/org/apache/hadoop/hive/serde2/typeinfo serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyHiveVarchar.java serde/src/java/org/apache/hadoop/hive/serde2/lazy/objectinspector/primitive/LazyHiveVarcharObjectInspector.java serde/src/java/org/apache/hadoop/hive/serde2/lazybinary/LazyBinaryHiveVarchar.java serde/src/java/org/apache/hadoop/hive/serde2/typeinfo/VarcharTypeParams.java serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/SettableHiveVarcharObjectInspector.java serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/HiveVarcharObjectInspector.java serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/JavaHiveVarcharObjectInspector.java serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableHiveVarcharObjectInspector.java serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableConstantHiveVarcharObjectInspector.java serde/src/java/org/apache/hadoop/hive/serde2/io/HiveVarcharWritable.java ql/src/test/results/clientnegative/invalid_varchar_length_3.q.out ql/src/test/results/clientnegative/invalid_varchar_length_1.q.out ql/src/test/results/clientnegative/invalid_varchar_length_2.q.out ql/src/test/results/clientpositive/varchar_union1.q.out ql/src/test/results/clientpositive/varchar_cast.q.out ql/src/test/results/clientpositive/alter_varchar1.q.out ql/src/test/results/clientpositive/varchar_udf1.q.out ql/src/test/results/clientpositive/varchar_2.q.out ql/src/test/results/clientpositive/partition_varchar1.q.out ql/src/test/results/clientpositive/varchar_nested_types.q.out ql/src/test/results/clientpositive/varchar_join1.q.out ql/src/test/results/clientpositive/varchar_comparison.q.out ql/src/test/results/clientpositive/ctas_varchar.q.out ql/src/test/results/clientpositive/varchar_1.q.out ql/src/test/queries/clientnegative/invalid_varchar_length_1.q ql/src/test/queries/clientnegative/invalid_varchar_length_2.q ql/src/test/queries/clientnegative/invalid_varchar_length_3.q ql/src/test/queries/clientpositive/varchar_cast.q ql/src/test/queries/clientpositive/varchar_join1.q ql/src/test/queries/clientpositive/alter_varchar1.q ql/src/test/queries/clientpositive/varchar_1.q ql/src/test/queries/clientpositive/partition_varchar1.q ql/src/test/queries/clientpositive/varchar_comparison.q ql/src/test/queries/clientpositive/ctas_varchar.q ql/src/test/queries/clientpositive/varchar_2.q ql/src/test/queries/clientpositive/varchar_nested_types.q ql/src/test/queries/clientpositive/varchar_udf1.q ql/src/test/queries/clientpositive/varchar_union1.q ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFToVarchar.java + svn update Fetching external item into 'hcatalog/src/test/e2e/harness' External at revision 1523203. At revision 1523203. + patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hive-ptest/working/scratch/build.patch + [[ -f /data/hive-ptest/working/scratch/build.patch ]] + chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh + /data/hive-ptest/working/scratch/smart-apply-patch.sh /data/hive-ptest/working/scratch/build.patch The patch does not appear to apply with p0 to p2 + exit 1 ' {noformat} This message is automatically generated. > Issue in colun type with data type as BINARY > -------------------------------------------- > > Key: HIVE-5221 > URL: https://issues.apache.org/jira/browse/HIVE-5221 > Project: Hive > Issue Type: Bug > Reporter: Arun Vasu > Assignee: Mohammad Kamrul Islam > Priority: Critical > Attachments: HIVE-5221.1.patch > > > Hi, > I am using Hive 10. When I create an external table with column type as > Binary, the query result on the table is showing some junk values for the > column with binary datatype. > Please find below the query I have used to create the table: > CREATE EXTERNAL TABLE BOOL1(NB BOOLEAN,email STRING, bitfld BINARY) > ROW FORMAT DELIMITED > FIELDS TERMINATED BY '^' > LINES TERMINATED BY '\n' > STORED AS TEXTFILE > LOCATION '/user/hivetables/testbinary'; > The query I have used is : select * from bool1 > The sample data in the hdfs file is: > 0^a...@abc.com^001 > 1^a...@abc.com^010 > ^a...@abc.com^011 > ^a...@abc.com^100 > t^a...@abc.com^101 > f^a...@abc.com^110 > true^a...@abc.com^111 > false^a...@abc.com^001 > 123^ ^01100010 > 12344^ ^01100001 > Please share your inputs if it is possible. > Thanks, > Arun -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira