@Peter Kim I verified in-house, it does not pick up any value at the table level: hive> desc formatted test01; OK # col_name data_type comment no int id string code string # Detailed Table Information Database: default Owner: hive CreateTime: Fri Jul 28 07:37:06 UTC 2017 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Location: hdfs://s:8020/apps/hive/warehouse/test01 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE{\"BASIC_STATS\":\"true\"} numFiles 0 numRows 0 orc.compress ? orc.create.index ? orc.row.index.stride? orc.stripe.size ? rawDataSize 0 totalSize 0 transient_lastDdlTime1501227426 ... View more

@Dhiraj Then, you need to run 'Drop database cascade'. ... View more

@Leonid Fedotov No, it is not supported even with lated HDP 2.6.1. https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_support-matrices/content/ch01.html ... View more

@rahul gulati I don't think we can handle \n characters with serde RegedSerDe, as by default all '\n' are retreated as line delimiters by Hive. You might need to handle new line using Omniture Data SerDe, refer link for details. ... View more

@pavan p Yarn logs are aggregated into HDFS directory '/app-logs/<user_name>/logs'. Refer link for more details on log aggregation. ... View more

@Simran Kaur Check the application log for job_1499692338187_45811 for details on the error. ... View more

@Xin Yang The issue could be due to product limitations wrt Date and Tez vectorization. Try running the query with hive.vectorized.execution.enabled=false. ... View more