[KYLIN-883] Using configurable option for Hive intermediate tables created by Kylin job

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v0.7.1
• Fix Version/s: v1.0, v1.4.0
• Sprint: Sprint 45, Sprint 46, Sprint 47, Sprint 48
• Assignee: Shao Feng Shi
• Reporter: Luke Han
• Created: 09/Jul/15 02:43
• Updated: 06/Sep/15 11:50
• Resolved: 06/Sep/15 11:50

Description

From user's feedback (Vineet Mishra):

Hi,

Would it be possible to move the cube specific hive reference table created
by the Kylin job to some specific schema as it creates too many table in
the default schema of hive which doesn't looks good!

Is it configurable to keep the database as some specific instead of default?

Thanks!

==================
1. Add one configuration option in kylin.properties for intermediate table sachem of Hive
2. put all intermediate tables under #1 schema

Issue Links

• breaks: KYLIN-975 change kylin.job.hive.database.for.intermediatetable cause job to fail
• is duplicated by: KYLIN-592 Enable administrator to setup database rather than "default" for intermediate hive tables