how to create pivot/transpose table in hive2019 Community Moderator ElectionHow rotate sql result entries into columns (pivot)Easy table transpose in hiveHow to transpose/pivot data in hive?how to query a column name 'date' in hive?Create Avro Hive table from S3 bucketCreate a date table in hiveHow create Table in Hive with Custom Date formatPivoting a large table in HiveHow to use pivot and group by in hiveHow to generate Date Series in HIVE? (Creating table)Creating Hive table for sub partitionsUnable to create Hive table, flaky metastore connections
Employee lack of ownership
It's a yearly task, alright
Co-worker team leader wants to inject his friend's awful software into our development. What should I say to our common boss?
Why doesn't using two cd commands in bash script execute the second command?
Why would a flight no longer considered airworthy be redirected like this?
How to change two letters closest to a string and one letter immediately after a string using notepad++
Are all passive ability checks floors for active ability checks?
SOQL: Populate a Literal List in WHERE IN Clause
If curse and magic is two sides of the same coin, why the former is forbidden?
What is the domain in a tikz parametric plot?
How to make healing in an exploration game interesting
Official degrees of earth’s rotation per day
How can I track script which gives me "command not found" right after the login?
Is it possible to upcast ritual spells?
How to simplify this time periods definition interface?
Could the Saturn V actually have launched astronauts around Venus?
Did Ender ever learn that he killed Stilson and/or Bonzo?
My adviser wants to be the first author
Look at your watch and tell me what time is it. vs Look at your watch and tell me what time it is
Why do Australian milk farmers need to protest supermarkets' milk price?
Life insurance that covers only simultaneous/dual deaths
Recruiter wants very extensive technical details about all of my previous work
What options are left, if Britain cannot decide?
How big is a MODIS 250m pixel in reality?
how to create pivot/transpose table in hive
2019 Community Moderator ElectionHow rotate sql result entries into columns (pivot)Easy table transpose in hiveHow to transpose/pivot data in hive?how to query a column name 'date' in hive?Create Avro Hive table from S3 bucketCreate a date table in hiveHow create Table in Hive with Custom Date formatPivoting a large table in HiveHow to use pivot and group by in hiveHow to generate Date Series in HIVE? (Creating table)Creating Hive table for sub partitionsUnable to create Hive table, flaky metastore connections
select st_date,st_symbol,st_adjclose from table;
2019-02-19 MSFT 107.71
2019-02-20 MSFT 107.15
2019-03-01 AAPL 174.97
2019-01-02 AAPL 157.25
2019-01-08 AMZN 1656.58
2019-01-07 AMZN 1629.51
2019-01-03 GOOGL 1025.47
2019-01-04 GOOGL 1078.07
date MSFT AAPL AMZN GOOGL
2019-02-19 107.71 141.58 141.58 141.58
2019-02-20 107.71 157.25 157.25 157.25
2019-02-22 110.97 157.25 157.25 157.25
hive
add a comment |
select st_date,st_symbol,st_adjclose from table;
2019-02-19 MSFT 107.71
2019-02-20 MSFT 107.15
2019-03-01 AAPL 174.97
2019-01-02 AAPL 157.25
2019-01-08 AMZN 1656.58
2019-01-07 AMZN 1629.51
2019-01-03 GOOGL 1025.47
2019-01-04 GOOGL 1078.07
date MSFT AAPL AMZN GOOGL
2019-02-19 107.71 141.58 141.58 141.58
2019-02-20 107.71 157.25 157.25 157.25
2019-02-22 110.97 157.25 157.25 157.25
hive
1
Why in the result AAPL = 141.58 for 2019-02-19 date? And why GOOGL = 141.58 ? Bother to describe your logic
– leftjoin
Mar 7 at 19:43
i made that for example. need table like that.
– Siva
Mar 8 at 7:08
Should it be sum or max() or what. Figures are confusing completely.
– leftjoin
Mar 8 at 7:45
General approach is like this: stackoverflow.com/a/39770081/2700344 or this stackoverflow.com/a/54535243/2700344. You should know values in advance, Hive does not support dynamic SQL
– leftjoin
Mar 8 at 7:53
add a comment |
select st_date,st_symbol,st_adjclose from table;
2019-02-19 MSFT 107.71
2019-02-20 MSFT 107.15
2019-03-01 AAPL 174.97
2019-01-02 AAPL 157.25
2019-01-08 AMZN 1656.58
2019-01-07 AMZN 1629.51
2019-01-03 GOOGL 1025.47
2019-01-04 GOOGL 1078.07
date MSFT AAPL AMZN GOOGL
2019-02-19 107.71 141.58 141.58 141.58
2019-02-20 107.71 157.25 157.25 157.25
2019-02-22 110.97 157.25 157.25 157.25
hive
select st_date,st_symbol,st_adjclose from table;
2019-02-19 MSFT 107.71
2019-02-20 MSFT 107.15
2019-03-01 AAPL 174.97
2019-01-02 AAPL 157.25
2019-01-08 AMZN 1656.58
2019-01-07 AMZN 1629.51
2019-01-03 GOOGL 1025.47
2019-01-04 GOOGL 1078.07
date MSFT AAPL AMZN GOOGL
2019-02-19 107.71 141.58 141.58 141.58
2019-02-20 107.71 157.25 157.25 157.25
2019-02-22 110.97 157.25 157.25 157.25
hive
hive
edited Mar 7 at 15:55
VK_217
7,75752347
7,75752347
asked Mar 7 at 13:50
SivaSiva
32
32
1
Why in the result AAPL = 141.58 for 2019-02-19 date? And why GOOGL = 141.58 ? Bother to describe your logic
– leftjoin
Mar 7 at 19:43
i made that for example. need table like that.
– Siva
Mar 8 at 7:08
Should it be sum or max() or what. Figures are confusing completely.
– leftjoin
Mar 8 at 7:45
General approach is like this: stackoverflow.com/a/39770081/2700344 or this stackoverflow.com/a/54535243/2700344. You should know values in advance, Hive does not support dynamic SQL
– leftjoin
Mar 8 at 7:53
add a comment |
1
Why in the result AAPL = 141.58 for 2019-02-19 date? And why GOOGL = 141.58 ? Bother to describe your logic
– leftjoin
Mar 7 at 19:43
i made that for example. need table like that.
– Siva
Mar 8 at 7:08
Should it be sum or max() or what. Figures are confusing completely.
– leftjoin
Mar 8 at 7:45
General approach is like this: stackoverflow.com/a/39770081/2700344 or this stackoverflow.com/a/54535243/2700344. You should know values in advance, Hive does not support dynamic SQL
– leftjoin
Mar 8 at 7:53
1
1
Why in the result AAPL = 141.58 for 2019-02-19 date? And why GOOGL = 141.58 ? Bother to describe your logic
– leftjoin
Mar 7 at 19:43
Why in the result AAPL = 141.58 for 2019-02-19 date? And why GOOGL = 141.58 ? Bother to describe your logic
– leftjoin
Mar 7 at 19:43
i made that for example. need table like that.
– Siva
Mar 8 at 7:08
i made that for example. need table like that.
– Siva
Mar 8 at 7:08
Should it be sum or max() or what. Figures are confusing completely.
– leftjoin
Mar 8 at 7:45
Should it be sum or max() or what. Figures are confusing completely.
– leftjoin
Mar 8 at 7:45
General approach is like this: stackoverflow.com/a/39770081/2700344 or this stackoverflow.com/a/54535243/2700344. You should know values in advance, Hive does not support dynamic SQL
– leftjoin
Mar 8 at 7:53
General approach is like this: stackoverflow.com/a/39770081/2700344 or this stackoverflow.com/a/54535243/2700344. You should know values in advance, Hive does not support dynamic SQL
– leftjoin
Mar 8 at 7:53
add a comment |
0
active
oldest
votes
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%2f55045401%2fhow-to-create-pivot-transpose-table-in-hive%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f55045401%2fhow-to-create-pivot-transpose-table-in-hive%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
1
Why in the result AAPL = 141.58 for 2019-02-19 date? And why GOOGL = 141.58 ? Bother to describe your logic
– leftjoin
Mar 7 at 19:43
i made that for example. need table like that.
– Siva
Mar 8 at 7:08
Should it be sum or max() or what. Figures are confusing completely.
– leftjoin
Mar 8 at 7:45
General approach is like this: stackoverflow.com/a/39770081/2700344 or this stackoverflow.com/a/54535243/2700344. You should know values in advance, Hive does not support dynamic SQL
– leftjoin
Mar 8 at 7:53