superset sql lab preview table returns state fail error 22
I have successfully created an external hive table from a druid datasource.
CREATE EXTERNAL TABLE druid_table_cstefan_test
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "wikipedia");
I am able to run queries from the hive-interactive shell. However, if I run queries
( or preview table ) from superset SQL lab it returns fail 22 ( see attached photo ).
using: HDP 3.0.1 cluster
hive-interactive = superset database name (backend: hive)
druid_table_cstefan_test = table name
As I see, if I try the below query, superset returns the results successfully
SELECT
`added`,
`channel`,
`cityname`,
`comment`,
`countryisocode`,
`countryname`,
`deleted`,
`delta`,
`isanonymous`,
`isminor`,
`isnew`,
`isrobot`,
`isunpatrolled`,
`metrocode`,
`namespace`,
`page`,
`regionisocode`,
`regionname`,
`user`
FROM default.druid_table_cstefan_test
LIMIT 100
So I guess that the issue is due to the column __time , this column is auto-created from druid when I create the "druid datasource".
__time data_type is "timestamp with local time zone"
Is there any workaround?
Druid datasource originates from "druid tutorial: loading a file" : http://druid.io/docs/latest/tutorials/tutorial-batch.html
hadoop hive druid superset
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
add a comment |
I have successfully created an external hive table from a druid datasource.
CREATE EXTERNAL TABLE druid_table_cstefan_test
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "wikipedia");
I am able to run queries from the hive-interactive shell. However, if I run queries
( or preview table ) from superset SQL lab it returns fail 22 ( see attached photo ).
using: HDP 3.0.1 cluster
hive-interactive = superset database name (backend: hive)
druid_table_cstefan_test = table name
As I see, if I try the below query, superset returns the results successfully
SELECT
`added`,
`channel`,
`cityname`,
`comment`,
`countryisocode`,
`countryname`,
`deleted`,
`delta`,
`isanonymous`,
`isminor`,
`isnew`,
`isrobot`,
`isunpatrolled`,
`metrocode`,
`namespace`,
`page`,
`regionisocode`,
`regionname`,
`user`
FROM default.druid_table_cstefan_test
LIMIT 100
So I guess that the issue is due to the column __time , this column is auto-created from druid when I create the "druid datasource".
__time data_type is "timestamp with local time zone"
Is there any workaround?
Druid datasource originates from "druid tutorial: loading a file" : http://druid.io/docs/latest/tutorials/tutorial-batch.html
hadoop hive druid superset
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
Are there logs for superset on the file system you could look at?
– cricket_007
Nov 22 '18 at 21:02
There is only one log file the file system ( /var/log/superset/ ), which logs are irrelevant to the above issue. As I see from superset service in Ambari, this is the only log directory
– Christos Stefanopoulos
Nov 23 '18 at 8:13
add a comment |
I have successfully created an external hive table from a druid datasource.
CREATE EXTERNAL TABLE druid_table_cstefan_test
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "wikipedia");
I am able to run queries from the hive-interactive shell. However, if I run queries
( or preview table ) from superset SQL lab it returns fail 22 ( see attached photo ).
using: HDP 3.0.1 cluster
hive-interactive = superset database name (backend: hive)
druid_table_cstefan_test = table name
As I see, if I try the below query, superset returns the results successfully
SELECT
`added`,
`channel`,
`cityname`,
`comment`,
`countryisocode`,
`countryname`,
`deleted`,
`delta`,
`isanonymous`,
`isminor`,
`isnew`,
`isrobot`,
`isunpatrolled`,
`metrocode`,
`namespace`,
`page`,
`regionisocode`,
`regionname`,
`user`
FROM default.druid_table_cstefan_test
LIMIT 100
So I guess that the issue is due to the column __time , this column is auto-created from druid when I create the "druid datasource".
__time data_type is "timestamp with local time zone"
Is there any workaround?
Druid datasource originates from "druid tutorial: loading a file" : http://druid.io/docs/latest/tutorials/tutorial-batch.html
hadoop hive druid superset
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
I have successfully created an external hive table from a druid datasource.
CREATE EXTERNAL TABLE druid_table_cstefan_test
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "wikipedia");
I am able to run queries from the hive-interactive shell. However, if I run queries
( or preview table ) from superset SQL lab it returns fail 22 ( see attached photo ).
using: HDP 3.0.1 cluster
hive-interactive = superset database name (backend: hive)
druid_table_cstefan_test = table name
As I see, if I try the below query, superset returns the results successfully
SELECT
`added`,
`channel`,
`cityname`,
`comment`,
`countryisocode`,
`countryname`,
`deleted`,
`delta`,
`isanonymous`,
`isminor`,
`isnew`,
`isrobot`,
`isunpatrolled`,
`metrocode`,
`namespace`,
`page`,
`regionisocode`,
`regionname`,
`user`
FROM default.druid_table_cstefan_test
LIMIT 100
So I guess that the issue is due to the column __time , this column is auto-created from druid when I create the "druid datasource".
__time data_type is "timestamp with local time zone"
Is there any workaround?
Druid datasource originates from "druid tutorial: loading a file" : http://druid.io/docs/latest/tutorials/tutorial-batch.html
hadoop hive druid superset
hadoop hive druid superset
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
edited Nov 23 '18 at 13:27
Christos Stefanopoulos
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
asked Nov 22 '18 at 13:05
Christos StefanopoulosChristos Stefanopoulos
11
11
Are there logs for superset on the file system you could look at?
– cricket_007
Nov 22 '18 at 21:02
There is only one log file the file system ( /var/log/superset/ ), which logs are irrelevant to the above issue. As I see from superset service in Ambari, this is the only log directory
– Christos Stefanopoulos
Nov 23 '18 at 8:13
add a comment |
Are there logs for superset on the file system you could look at?
– cricket_007
Nov 22 '18 at 21:02
There is only one log file the file system ( /var/log/superset/ ), which logs are irrelevant to the above issue. As I see from superset service in Ambari, this is the only log directory
– Christos Stefanopoulos
Nov 23 '18 at 8:13
Are there logs for superset on the file system you could look at?
– cricket_007
Nov 22 '18 at 21:02
Are there logs for superset on the file system you could look at?
– cricket_007
Nov 22 '18 at 21:02
There is only one log file the file system ( /var/log/superset/ ), which logs are irrelevant to the above issue. As I see from superset service in Ambari, this is the only log directory
– Christos Stefanopoulos
Nov 23 '18 at 8:13
There is only one log file the file system ( /var/log/superset/ ), which logs are irrelevant to the above issue. As I see from superset service in Ambari, this is the only log directory
– Christos Stefanopoulos
Nov 23 '18 at 8:13
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%2f53431686%2fsuperset-sql-lab-preview-table-returns-state-fail-error-22%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%2f53431686%2fsuperset-sql-lab-preview-table-returns-state-fail-error-22%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
Are there logs for superset on the file system you could look at?
– cricket_007
Nov 22 '18 at 21:02
There is only one log file the file system ( /var/log/superset/ ), which logs are irrelevant to the above issue. As I see from superset service in Ambari, this is the only log directory
– Christos Stefanopoulos
Nov 23 '18 at 8:13