Change table column name parquet format HadoopSchema Evolution in Parquet Hive tableHow do I get schema / column names from parquet file?hive doesn't change parquet schemaWhat are the pros and cons of parquet format compared to other formats?Schema evolution in parquet formatConversion of Parquet file format to sequence file formatCreating Hive table on Parquet file which has JSON dataData not being populated after altering the hive tablehive insert overwrite directory stored as parquet created columns with default namesloading parquet data in mysql table from hdfs using SQOOP
How does an ordinary object become radioactive?
Certain search in list
Is separation provided in class F airspace?
Does Disney no longer produce hand-drawn cartoon films?
Using "subway" as name for London Underground?
Playing a Character as Unobtrusive and Subservient, Yet Not Passive
When would it be advantageous not apply Training Ground's cost reduction?
Is an entry level DSLR going to shoot nice portrait pictures?
How did old MS-DOS games utilize various graphic cards?
I have a problem assistant manager, but I can't fire him
How do I prevent employees from either switching to competitors or opening their own business?
How to manually rewind film?
English word for "product of tinkering"
How can I end combat quickly when the outcome is inevitable?
CROSS APPLY produces outer join
Is it possible to have the age of the universe be unknown?
Generate basis elements of the Steenrod algebra
How to hide rifle during medieval town entrance inspection?
Is it legal for a bar bouncer to confiscate a fake ID
Why are trash cans referred to as "zafacón" in Puerto Rico?
Importance of Building Credit Score?
Why can my keyboard only digest 6 keypresses at a time?
How to tell your grandparent to not come to fetch you with their car?
Why we don’t make use of the t-distribution for constructing a confidence interval for a proportion?
Change table column name parquet format Hadoop
Schema Evolution in Parquet Hive tableHow do I get schema / column names from parquet file?hive doesn't change parquet schemaWhat are the pros and cons of parquet format compared to other formats?Schema evolution in parquet formatConversion of Parquet file format to sequence file formatCreating Hive table on Parquet file which has JSON dataData not being populated after altering the hive tablehive insert overwrite directory stored as parquet created columns with default namesloading parquet data in mysql table from hdfs using SQOOP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have table with columns a,b,c.
The data store on hdfs as parquet, is it possible to change specific column name even if the parquet already writted with the schema of a,b,c?
hadoop hive hdfs parquet
asked Mar 24 at 17:51
EvyatarEvyatar
536621
add a comment |
I have table with columns a,b,c.
The data store on hdfs as parquet, is it possible to change specific column name even if the parquet already writted with the schema of a,b,c?
hadoop hive hdfs parquet
asked Mar 24 at 17:51
EvyatarEvyatar
536621
add a comment |
I have table with columns a,b,c.
The data store on hdfs as parquet, is it possible to change specific column name even if the parquet already writted with the schema of a,b,c?
hadoop hive hdfs parquet
asked Mar 24 at 17:51
EvyatarEvyatar
536621
I have table with columns a,b,c.
The data store on hdfs as parquet, is it possible to change specific column name even if the parquet already writted with the schema of a,b,c?
hadoop hive hdfs parquet
hadoop hive hdfs parquet
asked Mar 24 at 17:51
EvyatarEvyatar
536621
asked Mar 24 at 17:51
EvyatarEvyatar
536621
asked Mar 24 at 17:51
EvyatarEvyatar
536621
asked Mar 24 at 17:51
EvyatarEvyatar
536621
asked Mar 24 at 17:51
EvyatarEvyatar
536621
536621
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Try using, ALTER TABLE
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| category_id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
alter table p change column category_id id int
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
answered Mar 24 at 19:10
BalaBala
6,42194384
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55326744%2fchange-table-column-name-parquet-format-hadoop%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try using, ALTER TABLE
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| category_id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
alter table p change column category_id id int
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
answered Mar 24 at 19:10
BalaBala
6,42194384
add a comment |
Try using, ALTER TABLE
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| category_id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
alter table p change column category_id id int
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
answered Mar 24 at 19:10
BalaBala
6,42194384
add a comment |
Try using, ALTER TABLE
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| category_id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
alter table p change column category_id id int
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
answered Mar 24 at 19:10
BalaBala
6,42194384
Try using, ALTER TABLE
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| category_id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
alter table p change column category_id id int
desc p;
+-------------------------+------------+----------+--+
| col_name | data_type | comment |
+-------------------------+------------+----------+--+
| id | int | |
| category_department_id | int | |
| category_name | string | |
+-------------------------+------------+----------+--+
answered Mar 24 at 19:10
BalaBala
6,42194384
answered Mar 24 at 19:10
BalaBala
6,42194384
answered Mar 24 at 19:10
BalaBala
6,42194384
answered Mar 24 at 19:10
BalaBala
6,42194384
6,42194384
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55326744%2fchange-table-column-name-parquet-format-hadoop%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
