| <!DOCTYPE html> |
| <!-- |
| | Generated by Apache Maven Doxia at 2018-03-12 |
| | Rendered using Apache Maven Fluido Skin 1.3.0 |
| --> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
| <head> |
| <meta charset="UTF-8" /> |
| <meta name="viewport" content="width=device-width, initial-scale=1.0" /> |
| <meta name="Date-Revision-yyyymmdd" content="20180312" /> |
| <meta http-equiv="Content-Language" content="en" /> |
| <title>Falcon - Hive Integration</title> |
| <link rel="stylesheet" href="./css/apache-maven-fluido-1.3.0.min.css" /> |
| <link rel="stylesheet" href="./css/site.css" /> |
| <link rel="stylesheet" href="./css/print.css" media="print" /> |
| |
| |
| <script type="text/javascript" src="./js/apache-maven-fluido-1.3.0.min.js"></script> |
| |
| |
| |
| <script type="text/javascript">$( document ).ready( function() { $( '.carousel' ).carousel( { interval: 3500 } ) } );</script> |
| |
| </head> |
| <body class="topBarDisabled"> |
| |
| |
| |
| |
| <div class="container"> |
| <div id="banner"> |
| <div class="pull-left"> |
| <div id="bannerLeft"> |
| <img src="images/falcon-logo.png" alt="Apache Falcon" width="200px" height="45px"/> |
| </div> |
| </div> |
| <div class="pull-right"> </div> |
| <div class="clear"><hr/></div> |
| </div> |
| |
| <div id="breadcrumbs"> |
| <ul class="breadcrumb"> |
| |
| |
| <li class=""> |
| <a href="index.html" title="Falcon"> |
| Falcon</a> |
| </li> |
| <li class="divider ">/</li> |
| <li class="">Hive Integration</li> |
| |
| |
| |
| <li id="publishDate" class="pull-right">Last Published: 2018-03-12</li> <li class="divider pull-right">|</li> |
| <li id="projectVersion" class="pull-right">Version: 0.11</li> |
| |
| </ul> |
| </div> |
| |
| |
| |
| <div id="bodyColumn" > |
| |
| <div class="section"> |
| <h2>Hive Integration<a name="Hive_Integration"></a></h2></div> |
| <div class="section"> |
| <h3>Overview<a name="Overview"></a></h3> |
| <p>Falcon provides data management functions for feeds declaratively. It allows users to represent feed locations as time-based partition directories on HDFS containing files.</p> |
| <p>Hive provides a simple and familiar database like tabular model of data management to its users, which are backed by HDFS. It supports two classes of tables, managed tables and external tables.</p> |
| <p>Falcon allows users to represent feed location as Hive tables. Falcon supports both managed and external tables and provide data management services for tables such as replication, eviction, archival, etc. Falcon will notify HCatalog as a side effect of either acquiring, replicating or evicting a data set instance and adds the missing capability of HCatalog table replication.</p> |
| <p>In the near future, Falcon will allow users to express pipeline processing in Hive scripts apart from Pig and Oozie workflows.</p></div> |
| <div class="section"> |
| <h3>Assumptions<a name="Assumptions"></a></h3> |
| <p></p> |
| <ul> |
| <li>Date is a mandatory first-level partition for Hive tables |
| <ul> |
| <li>Data availability triggers are based on date pattern in Oozie</li></ul></li> |
| <li>Tables must be created in Hive prior to adding it as a Feed in Falcon. |
| <ul> |
| <li>Duplicating this in Falcon will create confusion on the real source of truth. Also propagating schema changes</li></ul></li></ul>between systems is a hard problem. |
| <ul> |
| <li>Falcon does not know about the encoding of the data and data should be in HCatalog supported format.</li></ul></div> |
| <div class="section"> |
| <h3>Configuration<a name="Configuration"></a></h3> |
| <p>Falcon provides a system level option to enable Hive integration. Falcon must be configured with an implementation for the catalog registry. The default implementation for Hive is shipped with Falcon.</p> |
| <div class="source"> |
| <pre> |
| catalog.service.impl=org.apache.falcon.catalog.HiveCatalogService |
| |
| </pre></div></div> |
| <div class="section"> |
| <h3>Incompatible changes<a name="Incompatible_changes"></a></h3> |
| <p>Falcon depends heavily on data-availability triggers for scheduling Falcon workflows. Oozie must support data-availability triggers based on HCatalog partition availability. This is only available in oozie 4.x.</p> |
| <p>Hence, Falcon for Hive support needs Oozie 4.x.</p></div> |
| <div class="section"> |
| <h3>Oozie Shared Library setup<a name="Oozie_Shared_Library_setup"></a></h3> |
| <p>Falcon post Hive integration depends heavily on the <a class="externalLink" href="http://oozie.apache.org/docs/4.0.1/WorkflowFunctionalSpec.html#a17_HDFS_Share_Libraries_for_Workflow_Applications_since_Oozie_2.3">shared library feature of Oozie</a>. Since the sheer number of jars for HCatalog, Pig and Hive are in the many 10s in numbers, its quite daunting to redistribute the dependent jars from Falcon.</p> |
| <p><a class="externalLink" href="http://oozie.apache.org/docs/4.0.1/DG_QuickStart.html#Oozie_Share_Lib_Installation">This is a one time effort in Oozie setup and is quite straightforward.</a></p></div> |
| <div class="section"> |
| <h3>Approach<a name="Approach"></a></h3></div> |
| <div class="section"> |
| <h4>Entity Changes<a name="Entity_Changes"></a></h4> |
| <p></p> |
| <ul> |
| <li>Cluster DSL will have an additional registry-interface section, specifying the endpoint for the</li></ul>HCatalog server. If this is absent, no HCatalog publication will be done from Falcon for this cluster. |
| <div class="source"> |
| <pre>thrift://hcatalog-server:port |
| </pre></div> |
| <p></p> |
| <ul> |
| <li>Feed DSL will allow users to specify the URI (location) for HCatalog tables as:</li></ul> |
| <div class="source"> |
| <pre>catalog:database_name:table_name#partitions(key=value?)* |
| </pre></div> |
| <p></p> |
| <ul> |
| <li>Failure to publish to HCatalog will be retried (configurable # of retires) with back off. Permanent failures</li></ul>after all the retries are exhausted will fail the Falcon workflow</div> |
| <div class="section"> |
| <h4>Eviction<a name="Eviction"></a></h4> |
| <p></p> |
| <ul> |
| <li>Falcon will construct DDL statements to filter candidate partitions eligible for eviction drop partitions</li> |
| <li>Falcon will construct DDL statements to drop the eligible partitions</li> |
| <li>Additionally, Falcon will nuke the data on HDFS for external tables</li></ul></div> |
| <div class="section"> |
| <h4>Replication<a name="Replication"></a></h4> |
| <p></p> |
| <ul> |
| <li>Falcon will use HCatalog (Hive) API to export the data for a given table and the partition,</li></ul>which will result in a data collection that includes metadata on the data's storage format, the schema, how the data is sorted, what table the data came from, and values of any partition keys from that table. |
| <ul> |
| <li>Falcon will use discp tool to copy the exported data collection into the secondary cluster into a staging</li></ul>directory used by Falcon. |
| <ul> |
| <li>Falcon will then import the data into HCatalog (Hive) using the HCatalog (Hive) API. If the specified table does</li></ul>not yet exist, Falcon will create it, using the information in the imported metadata to set defaults for the table such as schema, storage format, etc. |
| <ul> |
| <li>The partition is not complete and hence not visible to users until all the data is committed on the secondary</li></ul>cluster, (no dirty reads) |
| <ul> |
| <li>Data collection is staged by Falcon and retries for copy continues from where it left off.</li> |
| <li>Failure to register with Hive will be retired. After all the attempts are exhausted,</li></ul>the data will be cleaned up by Falcon.</div> |
| <div class="section"> |
| <h4>Security<a name="Security"></a></h4> |
| <p>The user owns all data managed by Falcon. Falcon runs as the user who submitted the feed. Falcon will authenticate with HCatalog as the end user who owns the entity and the data.</p> |
| <p>For Hive managed tables, the table may be owned by the end user or “hive”. For “hive” owned tables, user will have to configure the feed as “hive”.</p></div> |
| <div class="section"> |
| <h3>Load on HCatalog from Falcon<a name="Load_on_HCatalog_from_Falcon"></a></h3> |
| <p>It generally depends on the frequency of the feeds configured in Falcon and how often data is ingested, replicated, or processed.</p></div> |
| <div class="section"> |
| <h3>User Impact<a name="User_Impact"></a></h3> |
| <p></p> |
| <ul> |
| <li>There should not be any impact to user due to this integration</li> |
| <li>Falcon will be fully backwards compatible</li> |
| <li>Users have a choice to either choose storage based on files on HDFS as they do today or use HCatalog for</li></ul>accessing the data in tables</div> |
| <div class="section"> |
| <h3>Known Limitations<a name="Known_Limitations"></a></h3></div> |
| <div class="section"> |
| <h4>Oozie<a name="Oozie"></a></h4> |
| <p></p> |
| <ul> |
| <li>Falcon with Hadoop 1.x requires copying guava jars manually to sharelib in oozie. Hadoop 2.x ships this.</li> |
| <li>hcatalog-pig-adapter needs to be copied manually to oozie sharelib.</li></ul> |
| <div class="source"> |
| <pre> |
| bin/hadoop dfs -copyFromLocal $LFS/share/lib/hcatalog/hcatalog-pig-adapter-0.5.0-incubating.jar share/lib/hcatalog |
| |
| </pre></div> |
| <p></p> |
| <ul> |
| <li>Oozie 4.x with Hadoop-2.x</li></ul>Replication jobs are submitted to oozie on the destination cluster. Oozie runs a table export job on RM on source cluster. Oozie server on the target cluster must be configured with source hadoop configs else jobs fail with errors on secure and non-secure clusters as below: |
| <div class="source"> |
| <pre> |
| org.apache.hadoop.security.token.SecretManager$InvalidToken: Password not found for ApplicationAttempt appattempt_1395965672651_0010_000002 |
| |
| </pre></div> |
| <p>Make sure all oozie servers that falcon talks to has the hadoop configs configured in oozie-site.xml</p> |
| <div class="source"> |
| <pre> |
| <property> |
| <name>oozie.service.HadoopAccessorService.hadoop.configurations</name> |
| <value>*=/etc/hadoop/conf,arpit-new-falcon-1.cs1cloud.internal:8020=/etc/hadoop-1,arpit-new-falcon-1.cs1cloud.internal:8032=/etc/hadoop-1,arpit-new-falcon-2.cs1cloud.internal:8020=/etc/hadoop-2,arpit-new-falcon-2.cs1cloud.internal:8032=/etc/hadoop-2,arpit-new-falcon-5.cs1cloud.internal:8020=/etc/hadoop-3,arpit-new-falcon-5.cs1cloud.internal:8032=/etc/hadoop-3</value> |
| <description> |
| Comma separated AUTHORITY=HADOOP_CONF_DIR, where AUTHORITY is the HOST:PORT of |
| the Hadoop service (JobTracker, HDFS). The wildcard '*' configuration is |
| used when there is no exact match for an authority. The HADOOP_CONF_DIR contains |
| the relevant Hadoop *-site.xml files. If the path is relative is looked within |
| the Oozie configuration directory; though the path can be absolute (i.e. to point |
| to Hadoop client conf/ directories in the local filesystem. |
| </description> |
| </property> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h4>Hive<a name="Hive"></a></h4> |
| <p></p> |
| <ul> |
| <li>Dated Partitions</li></ul>Falcon does not work well when table partition contains multiple dated columns. Falcon only works with a single dated partition. This is being tracked in FALCON-357 which is a limitation in Oozie. |
| <div class="source"> |
| <pre> |
| catalog:default:table4#year=${YEAR};month=${MONTH};day=${DAY};hour=${HOUR};minute=${MINUTE} |
| |
| </pre></div> |
| <p></p> |
| <ul> |
| <li><a class="externalLink" href="https://issues.apache.org/jira/browse/HIVE-5550">Hive table import fails for tables created with default text and sequence file formats using HCatalog API</a></li></ul>For some arcane reason, hive substitutes the output format for text and sequence to be prefixed with Hive. Hive table import fails since it compares against the input and output formats of the source table and they are different. Say, a table was created with out specifying the file format, it defaults to: |
| <div class="source"> |
| <pre> |
| fileFormat=TextFile, inputformat=org.apache.hadoop.mapred.TextInputFormat, outputformat=org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat |
| |
| </pre></div> |
| <p>But, when hive fetches the table from the metastore, it replaces the output format with org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat and the comparison between source and target table fails.</p> |
| <div class="source"> |
| <pre> |
| org.apache.hadoop.hive.ql.parse.ImportSemanticAnalyzer#checkTable |
| // check IF/OF/Serde |
| String existingifc = table.getInputFormatClass().getName(); |
| String importedifc = tableDesc.getInputFormat(); |
| String existingofc = table.getOutputFormatClass().getName(); |
| String importedofc = tableDesc.getOutputFormat(); |
| if ((!existingifc.equals(importedifc)) |
| || (!existingofc.equals(importedofc))) { |
| throw new SemanticException( |
| ErrorMsg.INCOMPATIBLE_SCHEMA |
| .getMsg(" Table inputformat/outputformats do not match")); |
| } |
| |
| </pre></div> |
| <p>The above is not an issue with Hive 0.13.</p></div> |
| <div class="section"> |
| <h3>Hive Examples<a name="Hive_Examples"></a></h3> |
| <p>Following is an example entity configuration for lifecycle management functions for tables in Hive.</p></div> |
| <div class="section"> |
| <h4>Hive Table Lifecycle Management - Replication and Retention<a name="Hive_Table_Lifecycle_Management_-_Replication_and_Retention"></a></h4></div> |
| <div class="section"> |
| <h5>Primary Cluster<a name="Primary_Cluster"></a></h5> |
| <div class="source"> |
| <pre> |
| <?xml version="1.0"?> |
| <!-- |
| Primary cluster configuration for demo vm |
| --> |
| <cluster colo="west-coast" description="Primary Cluster" |
| name="primary-cluster" |
| xmlns="uri:falcon:cluster:0.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> |
| <interfaces> |
| <interface type="readonly" endpoint="hftp://localhost:10070" |
| version="1.1.1" /> |
| <interface type="write" endpoint="hdfs://localhost:10020" |
| version="1.1.1" /> |
| <interface type="execute" endpoint="localhost:10300" |
| version="1.1.1" /> |
| <interface type="workflow" endpoint="http://localhost:11010/oozie/" |
| version="4.0.1" /> |
| <interface type="registry" endpoint="thrift://localhost:19083" |
| version="0.11.0" /> |
| <interface type="messaging" endpoint="tcp://localhost:61616?daemon=true" |
| version="5.4.3" /> |
| </interfaces> |
| <locations> |
| <location name="staging" path="/apps/falcon/staging" /> |
| <location name="temp" path="/tmp" /> |
| <location name="working" path="/apps/falcon/working" /> |
| </locations> |
| </cluster> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h5>BCP Cluster<a name="BCP_Cluster"></a></h5> |
| <div class="source"> |
| <pre> |
| <?xml version="1.0"?> |
| <!-- |
| BCP cluster configuration for demo vm |
| --> |
| <cluster colo="east-coast" description="BCP Cluster" |
| name="bcp-cluster" |
| xmlns="uri:falcon:cluster:0.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> |
| <interfaces> |
| <interface type="readonly" endpoint="hftp://localhost:20070" |
| version="1.1.1" /> |
| <interface type="write" endpoint="hdfs://localhost:20020" |
| version="1.1.1" /> |
| <interface type="execute" endpoint="localhost:20300" |
| version="1.1.1" /> |
| <interface type="workflow" endpoint="http://localhost:11020/oozie/" |
| version="4.0.1" /> |
| <interface type="registry" endpoint="thrift://localhost:29083" |
| version="0.11.0" /> |
| <interface type="messaging" endpoint="tcp://localhost:61616?daemon=true" |
| version="5.4.3" /> |
| </interfaces> |
| <locations> |
| <location name="staging" path="/apps/falcon/staging" /> |
| <location name="temp" path="/tmp" /> |
| <location name="working" path="/apps/falcon/working" /> |
| </locations> |
| </cluster> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h5>Feed with replication and eviction policy<a name="Feed_with_replication_and_eviction_policy"></a></h5> |
| <div class="source"> |
| <pre> |
| <?xml version="1.0"?> |
| <!-- |
| Replicating Hourly customer table from primary to secondary cluster. |
| --> |
| <feed description="Replicating customer table feed" name="customer-table-replicating-feed" |
| xmlns="uri:falcon:feed:0.1"> |
| <frequency>hours(1)</frequency> |
| <timezone>UTC</timezone> |
| |
| <clusters> |
| <cluster name="primary-cluster" type="source"> |
| <validity start="2013-09-24T00:00Z" end="2013-10-26T00:00Z"/> |
| <retention limit="hours(2)" action="delete"/> |
| </cluster> |
| <cluster name="bcp-cluster" type="target"> |
| <validity start="2013-09-24T00:00Z" end="2013-10-26T00:00Z"/> |
| <retention limit="days(30)" action="delete"/> |
| |
| <table uri="catalog:tgt_demo_db:customer_bcp#ds=${YEAR}-${MONTH}-${DAY}-${HOUR}" /> |
| </cluster> |
| </clusters> |
| |
| <table uri="catalog:src_demo_db:customer_raw#ds=${YEAR}-${MONTH}-${DAY}-${HOUR}" /> |
| |
| <ACL owner="seetharam" group="users" permission="0755"/> |
| <schema location="" provider="hcatalog"/> |
| </feed> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h4>Hive Table used in Processing Pipelines<a name="Hive_Table_used_in_Processing_Pipelines"></a></h4></div> |
| <div class="section"> |
| <h5>Primary Cluster<a name="Primary_Cluster"></a></h5> |
| <p>The cluster definition from the lifecycle example can be used.</p></div> |
| <div class="section"> |
| <h5>Input Feed<a name="Input_Feed"></a></h5> |
| <div class="source"> |
| <pre> |
| <?xml version="1.0"?> |
| <feed description="clicks log table " name="input-table" xmlns="uri:falcon:feed:0.1"> |
| <groups>online,bi</groups> |
| <frequency>hours(1)</frequency> |
| <timezone>UTC</timezone> |
| |
| <clusters> |
| <cluster name="##cluster##" type="source"> |
| <validity start="2010-01-01T00:00Z" end="2012-04-21T00:00Z"/> |
| <retention limit="hours(24)" action="delete"/> |
| </cluster> |
| </clusters> |
| |
| <table uri="catalog:falcon_db:input_table#ds=${YEAR}-${MONTH}-${DAY}-${HOUR}" /> |
| |
| <ACL owner="testuser" group="group" permission="0x755"/> |
| <schema location="/schema/clicks" provider="protobuf"/> |
| </feed> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h5>Output Feed<a name="Output_Feed"></a></h5> |
| <div class="source"> |
| <pre> |
| <?xml version="1.0"?> |
| <feed description="clicks log identity table" name="output-table" xmlns="uri:falcon:feed:0.1"> |
| <groups>online,bi</groups> |
| <frequency>hours(1)</frequency> |
| <timezone>UTC</timezone> |
| |
| <clusters> |
| <cluster name="##cluster##" type="source"> |
| <validity start="2010-01-01T00:00Z" end="2012-04-21T00:00Z"/> |
| <retention limit="hours(24)" action="delete"/> |
| </cluster> |
| </clusters> |
| |
| <table uri="catalog:falcon_db:output_table#ds=${YEAR}-${MONTH}-${DAY}-${HOUR}" /> |
| |
| <ACL owner="testuser" group="group" permission="0x755"/> |
| <schema location="/schema/clicks" provider="protobuf"/> |
| </feed> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h5>Process<a name="Process"></a></h5> |
| <div class="source"> |
| <pre> |
| <?xml version="1.0"?> |
| <process name="##processName##" xmlns="uri:falcon:process:0.1"> |
| <clusters> |
| <cluster name="##cluster##"> |
| <validity end="2012-04-22T00:00Z" start="2012-04-21T00:00Z"/> |
| </cluster> |
| </clusters> |
| |
| <parallel>1</parallel> |
| <order>FIFO</order> |
| <frequency>days(1)</frequency> |
| <timezone>UTC</timezone> |
| |
| <inputs> |
| <input end="today(0,0)" start="today(0,0)" feed="input-table" name="input"/> |
| </inputs> |
| |
| <outputs> |
| <output instance="now(0,0)" feed="output-table" name="output"/> |
| </outputs> |
| |
| <properties> |
| <property name="blah" value="blah"/> |
| </properties> |
| |
| <workflow engine="pig" path="/falcon/test/apps/pig/table-id.pig"/> |
| |
| <retry policy="periodic" delay="minutes(10)" attempts="3"/> |
| </process> |
| |
| </pre></div></div> |
| <div class="section"> |
| <h5>Pig Script<a name="Pig_Script"></a></h5> |
| <div class="source"> |
| <pre> |
| A = load '$input_database.$input_table' using org.apache.hcatalog.pig.HCatLoader(); |
| B = FILTER A BY $input_filter; |
| C = foreach B generate id, value; |
| store C into '$output_database.$output_table' USING org.apache.hcatalog.pig.HCatStorer('$output_dataout_partitions'); |
| |
| </pre></div></div> |
| </div> |
| </div> |
| |
| <hr/> |
| |
| <footer> |
| <div class="container"> |
| <div class="row span12">Copyright © 2013-2018 |
| <a href="http://www.apache.org">Apache Software Foundation</a>. |
| All Rights Reserved. |
| |
| </div> |
| |
| |
| <p id="poweredBy" class="pull-right"> |
| <a href="http://maven.apache.org/" title="Built by Maven" class="poweredBy"> |
| <img class="builtBy" alt="Built by Maven" src="./images/logos/maven-feather.png" /> |
| </a> |
| </p> |
| |
| </div> |
| </footer> |
| </body> |
| </html> |
