Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIVE view error from Tweet counts topology

Re: HIVE view error from Tweet counts topology

Contributor

HDP 2.4 + Ambari 2.2.1.1

Highlighted

Re: HIVE view error from Tweet counts topology

Contributor

@Wellington,

Add follwing as part of your table creation.

STORED AS ORC tblproperties ('transactional'='true'); alter table ttsa.tweets SET TBLPROPERTIES ('transactional'='true');

transactional" and " NO_AUTO_COMPACTION" table properties are case-sensitive in Hive releases 0.x and 1.0, but they are case-insensitive starting with release 1.1.0 ( HIVE-8308).Add comment Reward user Share