phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Talanki, Vikash" <vtala...@visa.com>
Subject Phoenix 4.7 CSVBulk Loading not populating index tables
Date Tue, 14 Jun 2016 18:18:34 GMT
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;
color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>
<div>
<div><span style="color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif;
font-size: 13px; line-height: normal; widows: 1; background-color: rgb(255, 255, 255);">Hi
All,</span>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
<br>
</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
I'm currently trying to load CSV files in Phoenix table using CSVBulkLoad tool using&nbsp;<b>phoenix-4.7.0-HBase-1.1-<wbr>client.jar</b>&nbsp;in
Hortonworks.</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
I have a phoenix table and 6 indexes were created on this table. According to CSV Bulk Load
documentation -&nbsp;<a href="https://phoenix.apache.org/bulk_dataload.html" target="_blank"
rel="nofollow" style="margin: 0px; padding: 0px; border: 0px; text-decoration: none; color:
rgb(102, 17, 204); cursor: pointer;">https://phoenix.apache.org/<wbr>bulk_dataload.html</a>,
 it should run 7 MR jobs and load data into main table and 6 index tables.</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
But I'm seeing that when I use the above 4.7 jar, it is running only 1 MR job and loading
data into only main data table and first index table.&nbsp;</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
When I use 4.5.2 jar, it runs 7 MR jobs as documented and loads the data in all tables.</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
<br>
</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
So is this the issue with&nbsp;<b>phoenix-4.7.0-HBase-1.1-<wbr>client.jar&nbsp;</b>jar?
Any work around if I want to use 4.7 jar?</div>
</div>
<div style="margin: 0px; padding: 0px; border: 0px; color: rgb(34, 34, 34); font-family:
Arial, Helvetica, sans-serif; font-size: 13px; line-height: normal; widows: 1; background-color:
rgb(255, 255, 255);">
<br>
</div>
<div>
<div id="MAC_OUTLOOK_SIGNATURE">
<div><font class="Apple-style-span" color="#000000"><font class="Apple-style-span"
face="Calibri">Thanks,</font></font></div>
<div><font class="Apple-style-span" color="#000000"><font class="Apple-style-span"
face="Calibri"><span class="Apple-style-span" style="font-size: 14px;">Vikash Talanki</span></font></font></div>
</div>
</div>
</div>
</div>
</body>
</html>
Mime
View raw message