Skip to content

Commit 64d7589

Browse files
rjagiewichrjagiewich
authored
Merge pull request #8861 from Lingxi-Li/lingxl/java
[SSIS] Update Java section of HDFS File Dest
2 parents 96a929e + 4ff81f3 commit 64d7589

1 file changed

Lines changed: 36 additions & 43 deletions

File tree

‎docs/integration-services/data-flow/hdfs-file-destination.md‎

Lines changed: 36 additions & 43 deletions
Original file line numberDiff line numberDiff line change
@@ -7,68 +7,61 @@ ms.prod_service: "integration-services"
77
ms.reviewer: ""
88
ms.technology: integration-services
99
ms.topic: conceptual
10-
f1_keywords:
10+
f1_keywords:
1111
- "sql13.ssis.designer.hdfsfiledest.f1"
1212
ms.assetid: 4338ce9f-c077-4301-aca5-47ed070ec94d
1313
author: "douglaslMS"
1414
ms.author: "douglasl"
1515
manager: craigg
1616
---
1717
# HDFS File Destination
18-
The HDFS File Destination component enables an SSIS package to write data to a HDFS file. The supported file formats are Text, Avro, and ORC.
19-
20-
To configure the HDFS File Destination, drag and drop the HDFS File Source on the data flow designer and double-click the component to open the editor.
21-
22-
![HDFS File Destination Editor](../../integration-services/data-flow/media/hdfs-file-dest.png "HDFS File Destination Editor")
23-
24-
## Options
25-
Configure the following options on the **General** tab of the **Hadoop File Destination Editor** dialog box.
26-
27-
|Field|Description|
28-
|-----------|-----------------|
29-
|**Hadoop Connection**|Specify an existing Hadoop Connection Manager or create a new one. This connection manager indicates where the HDFS files are hosted.|
30-
|**File Path**|Specify the name of the HDFS file.|
31-
|**File format**|Specify the format for the HDFS file. The available options are Text, Avro, and ORC.|
32-
|**Column delimiter character**|If you select Text format, specify the column delimiter character.|
33-
|**Column names in the first data row**|If you select Text format, specify whether the first row in the file contains column names.|
34-
35-
After you configure these options, select the **Columns** tab to map source columns to destination columns in the data flow.
18+
The HDFS File Destination component enables an SSIS package to write data to a HDFS file. The supported file formats are Text, Avro, and ORC.
3619

37-
::: moniker range=">= sql-server-ver15"
38-
## Prerequisite for ORC format
20+
To configure the HDFS File Destination, drag and drop the HDFS File Source on the data flow designer and double-click the component to open the editor.
3921

40-
Before you can use the ORC file format, you have to install the Java Runtime Environment (JRE) with version 1.7.51 or higher for the appropriate platform.
22+
![HDFS File Destination Editor](../../integration-services/data-flow/media/hdfs-file-dest.png "HDFS File Destination Editor")
4123

42-
Both the Zulu and the Oracle JRE are supported.
43-
- [Zulu JRE](https://www.azul.com/downloads/zulu/zulu-windows/)
44-
- [Oracle JRE](https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html)
24+
## Options
25+
Configure the following options on the **General** tab of the **Hadoop File Destination Editor** dialog box.
4526

46-
### Set up the Zulu JRE
27+
|Field|Description|
28+
|-----------|-----------------|
29+
|**Hadoop Connection**|Specify an existing Hadoop Connection Manager or create a new one. This connection manager indicates where the HDFS files are hosted.|
30+
|**File Path**|Specify the name of the HDFS file.|
31+
|**File format**|Specify the format for the HDFS file. The available options are Text, Avro, and ORC.|
32+
|**Column delimiter character**|If you select Text format, specify the column delimiter character.|
33+
|**Column names in the first data row**|If you select Text format, specify whether the first row in the file contains column names.|
4734

48-
1. Download and extract the Zulu OpenJDK installation zip package.
35+
After you configure these options, select the **Columns** tab to map source columns to destination columns in the data flow.
4936

50-
2. From the Command Prompt, run `sysdm.cpl`.
37+
::: moniker range=">= sql-server-ver15"
5138

52-
3. On the **Advanced** tab, select **Environment Variables**.
39+
## Prerequisite for ORC File Format
40+
Java is required to use ORC file format.
41+
Architecture (32/64-bit) of the Java build should match that of the SSIS runtime to use.
42+
The following Java builds have been tested.
5343

54-
4. Under the **System variables** section, select **New**.
44+
- [Zulu's OpenJDK 8u192](https://www.azul.com/downloads/zulu/zulu-windows/)
45+
- [Oracle's Java SE Runtime Environment 8u192](https://www.oracle.com/technetwork/java/javase/downloads/java-archive-javase8-2177648.html)
5546

47+
### Set Up Zulu's OpenJDK
48+
1. Download and extract the installation zip package.
49+
2. From the Command Prompt, run `sysdm.cpl`.
50+
3. On the **Advanced** tab, select **Environment Variables**.
51+
4. Under the **System variables** section, select **New**.
5652
5. Enter `JAVA_HOME` for the **Variable name**.
57-
58-
6. Select **Browse Directory**, navigate to the Zulu OpenJDK installation folder, and select the `jre` subfolder. Then select OK. The variable value is populated automatically.
59-
53+
6. Select **Browse Directory**, navigate to the extracted folder, and select the `jre` subfolder.
54+
Then select **OK**, and the **Variable value** is populated automatically.
6055
7. Select **OK** to close the **New System Variable** dialog box.
56+
8. Select **OK** to close the **Environment Variables** dialog box.
57+
9. Select **OK** to close the **System Properties** dialog box.
6158

62-
8. Select **OK** to close the Environment Variables dialog box.
63-
64-
### Set up the Oracle JRE
65-
66-
1. Download and run the Oracle JRE exe installer.
67-
68-
1. Follow the installer instructions to complete setup.
59+
### Set Up Oracle's Java SE Runtime Environment
60+
1. Download and run the exe installer.
61+
2. Follow the installer instructions to complete setup.
6962

7063
::: moniker-end
7164

72-
## See Also
73-
[Hadoop Connection Manager](../../integration-services/connection-manager/hadoop-connection-manager.md)
74-
[HDFS File Source](../../integration-services/data-flow/hdfs-file-source.md)
65+
## See Also
66+
[Hadoop Connection Manager](../../integration-services/connection-manager/hadoop-connection-manager.md)
67+
[HDFS File Source](../../integration-services/data-flow/hdfs-file-source.md)

0 commit comments

Comments
 (0)