[jira] [Commented] (HIVE-10968) Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found
[ https://issues.apache.org/jira/browse/HIVE-10968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14584321#comment-14584321 ] Sushanth Sowmyan commented on HIVE-10968: - +1, looks good to me - it's now similar to the linux hive parsing of HIVE_AUX_JARS_PATH. Thanks, Hari! Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found --- Key: HIVE-10968 URL: https://issues.apache.org/jira/browse/HIVE-10968 Project: Hive Issue Type: Bug Components: HiveServer2 Environment: Windows Reporter: Takahiko Saito Assignee: Hari Sankar Sivarama Subramaniyan Fix For: 1.3.0, 1.2.1, 2.0.0 Attachments: HIVE-10968.1.patch, HIVE-10968.2.patch NO PRECOMMIT TESTS Run the following via beeline: {noformat}0: jdbc:hive2://localhost:10001 analyze table all100kjson compute statistics; 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=parse from=org.apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO parse.ParseDriver: Parsing command: analyze table all100kjson compute statistics 15/06/05 20:44:11 INFO parse.ParseDriver: Parse Completed 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG method=parse start=1433537051075 end=1433537051077 duration=2 from=org. apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Invoking analyze on original query 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Starting Semantic Analysis 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed phase 1 of Semantic Analysis 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for source tables 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_table : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_table : db=default tbl=a ll100kjson 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_table : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_table : db=default tbl=a ll100kjson 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for subqueries 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for destination tables 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed getting MetaData in Semantic Analysis 15/06/05 20:44:11 INFO common.FileUtils: Creating directory if it doesn't exist: hdfs://dal-hs211:8020/user/hcat/tests/d ata/all100kjson/.hive-staging_hive_2015-06-05_20-44-11_075_4520028480897676073-5 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Set stats collection dir : hdfs://dal-hs211:8020/user/hcat/tes ts/data/all100kjson/.hive-staging_hive_2015-06-05_20-44-11_075_4520028480897676073-5/-ext-1 15/06/05 20:44:11 INFO ppd.OpProcFactory: Processing for TS(5) 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=partition-retrieving from=org.apache.hadoop.hive.ql.optimizer.ppr .PartitionPruner 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG method=partition-retrieving start=1433537051345 end=1433537051345 durat ion=0 from=org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_indexes : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_indexes : db=default tbl =all100kjson 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_indexes : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_indexes : db=default tbl =all100kjson 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.Vectorizer: Validating MapWork... 15/06/05 20:44:11 INFO physical.Vectorizer: Input format: org.apache.hadoop.mapred.TextInputFormat, doesn't provide vect orized input 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed plan generation
[jira] [Commented] (HIVE-10968) Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found
[ https://issues.apache.org/jira/browse/HIVE-10968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14581242#comment-14581242 ] Hari Sankar Sivarama Subramaniyan commented on HIVE-10968: -- Committed to branch-1 as well Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found --- Key: HIVE-10968 URL: https://issues.apache.org/jira/browse/HIVE-10968 Project: Hive Issue Type: Bug Components: HiveServer2 Environment: Windows Reporter: Takahiko Saito Assignee: Hari Sankar Sivarama Subramaniyan Fix For: 1.3.0, 1.2.1, 2.0.0 Attachments: HIVE-10968.1.patch NO PRECOMMIT TESTS Run the following via beeline: {noformat}0: jdbc:hive2://localhost:10001 analyze table all100kjson compute statistics; 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=parse from=org.apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO parse.ParseDriver: Parsing command: analyze table all100kjson compute statistics 15/06/05 20:44:11 INFO parse.ParseDriver: Parse Completed 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG method=parse start=1433537051075 end=1433537051077 duration=2 from=org. apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Invoking analyze on original query 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Starting Semantic Analysis 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed phase 1 of Semantic Analysis 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for source tables 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_table : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_table : db=default tbl=a ll100kjson 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_table : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_table : db=default tbl=a ll100kjson 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for subqueries 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for destination tables 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed getting MetaData in Semantic Analysis 15/06/05 20:44:11 INFO common.FileUtils: Creating directory if it doesn't exist: hdfs://dal-hs211:8020/user/hcat/tests/d ata/all100kjson/.hive-staging_hive_2015-06-05_20-44-11_075_4520028480897676073-5 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Set stats collection dir : hdfs://dal-hs211:8020/user/hcat/tes ts/data/all100kjson/.hive-staging_hive_2015-06-05_20-44-11_075_4520028480897676073-5/-ext-1 15/06/05 20:44:11 INFO ppd.OpProcFactory: Processing for TS(5) 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=partition-retrieving from=org.apache.hadoop.hive.ql.optimizer.ppr .PartitionPruner 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG method=partition-retrieving start=1433537051345 end=1433537051345 durat ion=0 from=org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_indexes : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_indexes : db=default tbl =all100kjson 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_indexes : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_indexes : db=default tbl =all100kjson 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.Vectorizer: Validating MapWork... 15/06/05 20:44:11 INFO physical.Vectorizer: Input format: org.apache.hadoop.mapred.TextInputFormat, doesn't provide vect orized input 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed plan generation 15/06/05 20:44:11 INFO ql.Driver: Semantic Analysis
[jira] [Commented] (HIVE-10968) Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found
[ https://issues.apache.org/jira/browse/HIVE-10968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14579286#comment-14579286 ] Thejas M Nair commented on HIVE-10968: -- +1 Thanks for the patch Hari! Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found --- Key: HIVE-10968 URL: https://issues.apache.org/jira/browse/HIVE-10968 Project: Hive Issue Type: Bug Components: HiveServer2 Environment: Windows Reporter: Takahiko Saito Assignee: Hari Sankar Sivarama Subramaniyan Fix For: 1.2.1 Attachments: HIVE-10968.1.patch NO PRECOMMIT TESTS Run the following via beeline: {noformat}0: jdbc:hive2://localhost:10001 analyze table all100kjson compute statistics; 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=parse from=org.apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO parse.ParseDriver: Parsing command: analyze table all100kjson compute statistics 15/06/05 20:44:11 INFO parse.ParseDriver: Parse Completed 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG method=parse start=1433537051075 end=1433537051077 duration=2 from=org. apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Invoking analyze on original query 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Starting Semantic Analysis 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed phase 1 of Semantic Analysis 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for source tables 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_table : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_table : db=default tbl=a ll100kjson 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_table : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_table : db=default tbl=a ll100kjson 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for subqueries 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Get metadata for destination tables 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed getting MetaData in Semantic Analysis 15/06/05 20:44:11 INFO common.FileUtils: Creating directory if it doesn't exist: hdfs://dal-hs211:8020/user/hcat/tests/d ata/all100kjson/.hive-staging_hive_2015-06-05_20-44-11_075_4520028480897676073-5 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Set stats collection dir : hdfs://dal-hs211:8020/user/hcat/tes ts/data/all100kjson/.hive-staging_hive_2015-06-05_20-44-11_075_4520028480897676073-5/-ext-1 15/06/05 20:44:11 INFO ppd.OpProcFactory: Processing for TS(5) 15/06/05 20:44:11 INFO log.PerfLogger: PERFLOG method=partition-retrieving from=org.apache.hadoop.hive.ql.optimizer.ppr .PartitionPruner 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG method=partition-retrieving start=1433537051345 end=1433537051345 durat ion=0 from=org.apache.hadoop.hive.ql.optimizer.ppr.PartitionPruner 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_indexes : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_indexes : db=default tbl =all100kjson 15/06/05 20:44:11 INFO metastore.HiveMetaStore: 5: get_indexes : db=default tbl=all100kjson 15/06/05 20:44:11 INFO HiveMetaStore.audit: ugi=hadoopqa ip=unknown-ip-addr cmd=get_indexes : db=default tbl =all100kjson 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Looking for table scans where optimization is applicable 15/06/05 20:44:11 INFO physical.NullScanTaskDispatcher: Found 0 null table scans 15/06/05 20:44:11 INFO physical.Vectorizer: Validating MapWork... 15/06/05 20:44:11 INFO physical.Vectorizer: Input format: org.apache.hadoop.mapred.TextInputFormat, doesn't provide vect orized input 15/06/05 20:44:11 INFO parse.ColumnStatsSemanticAnalyzer: Completed plan generation 15/06/05 20:44:11 INFO ql.Driver: Semantic Analysis Completed 15/06/05 20:44:11 INFO log.PerfLogger: /PERFLOG