How to group values based on key in Alibaba MaxCompute?
I am facing issues when trying to group the values based on the key in Alibaba MaxCompute. I used similar queries before in Alibaba Cloud MaxCompute but now it throws me an error.
For instance,
SELECT * FROM table GROUP BY key;
It should work but it throws me error like
FAILED: ODPS-0130071:[1,8] Semantic analysis exception - column
reference table.value should appear in GROUP BY key
Anyone could help me with this to understand why this error occurs.
hadoop hive alibaba-cloud
add a comment |
I am facing issues when trying to group the values based on the key in Alibaba MaxCompute. I used similar queries before in Alibaba Cloud MaxCompute but now it throws me an error.
For instance,
SELECT * FROM table GROUP BY key;
It should work but it throws me error like
FAILED: ODPS-0130071:[1,8] Semantic analysis exception - column
reference table.value should appear in GROUP BY key
Anyone could help me with this to understand why this error occurs.
hadoop hive alibaba-cloud
add a comment |
I am facing issues when trying to group the values based on the key in Alibaba MaxCompute. I used similar queries before in Alibaba Cloud MaxCompute but now it throws me an error.
For instance,
SELECT * FROM table GROUP BY key;
It should work but it throws me error like
FAILED: ODPS-0130071:[1,8] Semantic analysis exception - column
reference table.value should appear in GROUP BY key
Anyone could help me with this to understand why this error occurs.
hadoop hive alibaba-cloud
I am facing issues when trying to group the values based on the key in Alibaba MaxCompute. I used similar queries before in Alibaba Cloud MaxCompute but now it throws me an error.
For instance,
SELECT * FROM table GROUP BY key;
It should work but it throws me error like
FAILED: ODPS-0130071:[1,8] Semantic analysis exception - column
reference table.value should appear in GROUP BY key
Anyone could help me with this to understand why this error occurs.
hadoop hive alibaba-cloud
hadoop hive alibaba-cloud
edited Nov 22 '18 at 2:28
dhilt
8,18742243
8,18742243
asked Nov 21 '18 at 16:54
Ranjith UdayakumarRanjith Udayakumar
32313
32313
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In the earlier version of MaxCompute, select * from group by key
is supported even when the columns that match * are not included in the GROUP BY key. Compatible with Hive, MaxCompute 2.0 prohibits this syntax unless the GROUP BY list is a column in all source tables
Examples:
Scenario 1: The GROUP BY key does not include all columns.
Incorrect Syntax:
SELECT * FROM t GROUP BY key;
Correct Syntax:
SELECT DISTINCT key FROM t;
Scenario 2: The GROUP BY key includes all columns.
Not recommended syntax:
SELECT * FROM t GROUP BY key, value; -- t has columns key and value
Recommended syntax:
SELECT DISTINCT key, value FROM t;
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%2f53417013%2fhow-to-group-values-based-on-key-in-alibaba-maxcompute%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
In the earlier version of MaxCompute, select * from group by key
is supported even when the columns that match * are not included in the GROUP BY key. Compatible with Hive, MaxCompute 2.0 prohibits this syntax unless the GROUP BY list is a column in all source tables
Examples:
Scenario 1: The GROUP BY key does not include all columns.
Incorrect Syntax:
SELECT * FROM t GROUP BY key;
Correct Syntax:
SELECT DISTINCT key FROM t;
Scenario 2: The GROUP BY key includes all columns.
Not recommended syntax:
SELECT * FROM t GROUP BY key, value; -- t has columns key and value
Recommended syntax:
SELECT DISTINCT key, value FROM t;
add a comment |
In the earlier version of MaxCompute, select * from group by key
is supported even when the columns that match * are not included in the GROUP BY key. Compatible with Hive, MaxCompute 2.0 prohibits this syntax unless the GROUP BY list is a column in all source tables
Examples:
Scenario 1: The GROUP BY key does not include all columns.
Incorrect Syntax:
SELECT * FROM t GROUP BY key;
Correct Syntax:
SELECT DISTINCT key FROM t;
Scenario 2: The GROUP BY key includes all columns.
Not recommended syntax:
SELECT * FROM t GROUP BY key, value; -- t has columns key and value
Recommended syntax:
SELECT DISTINCT key, value FROM t;
add a comment |
In the earlier version of MaxCompute, select * from group by key
is supported even when the columns that match * are not included in the GROUP BY key. Compatible with Hive, MaxCompute 2.0 prohibits this syntax unless the GROUP BY list is a column in all source tables
Examples:
Scenario 1: The GROUP BY key does not include all columns.
Incorrect Syntax:
SELECT * FROM t GROUP BY key;
Correct Syntax:
SELECT DISTINCT key FROM t;
Scenario 2: The GROUP BY key includes all columns.
Not recommended syntax:
SELECT * FROM t GROUP BY key, value; -- t has columns key and value
Recommended syntax:
SELECT DISTINCT key, value FROM t;
In the earlier version of MaxCompute, select * from group by key
is supported even when the columns that match * are not included in the GROUP BY key. Compatible with Hive, MaxCompute 2.0 prohibits this syntax unless the GROUP BY list is a column in all source tables
Examples:
Scenario 1: The GROUP BY key does not include all columns.
Incorrect Syntax:
SELECT * FROM t GROUP BY key;
Correct Syntax:
SELECT DISTINCT key FROM t;
Scenario 2: The GROUP BY key includes all columns.
Not recommended syntax:
SELECT * FROM t GROUP BY key, value; -- t has columns key and value
Recommended syntax:
SELECT DISTINCT key, value FROM t;
answered Nov 21 '18 at 19:34
VINVIN
14112
14112
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%2f53417013%2fhow-to-group-values-based-on-key-in-alibaba-maxcompute%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