Solr datatype for interval provided by postgresqlPostgreSQL “DESCRIBE TABLE”Show tables in PostgreSQLCreating a copy of a database in PostgreSQLHow can I drop all the tables in a PostgreSQL database?PostgreSQL: Difference between text and varchar (character varying)Import SQL dump into PostgreSQL databaseHow to exit from PostgreSQL command line utility: psqlSolr vs. ElasticSearchWhich version of PostgreSQL am I running?Indexing PostgreSQL BYTEA data with Solr & Tika
How to honestly answer questions from a girlfriend like "How did you find this place" without giving the impression I'm always talking about my exes?
In special relativity is mass just a measure of all other energy than kinetic?
Do First Order blasters maintain a record of when they were fired?
Can I send medicine to an American visitor in Canada?
How could an animal "smell" carbon monoxide?
When to ask for constructive criticism?
Is 7000 words too long for a chapter?
Will it hurt my career to work as a graphic designer in a startup for beauty and skin care?
Identification of an AC transformer
If I stood next to a piece of metal heated to a million degrees, but in a perfect vacuum, would I feel hot?
I do not have power to all my breakers
Why run a service as a system user?
What is the superlative of ipse?
What are the arguments for California’s nonpartisan blanket (jungle) primaries?
Why aren't globular clusters disk shaped
Could a planet have a naturally occuring moon at one of its Lagrange points?
Animal Shelter Management C++
What's the phrasal verb for carbonated drinks exploding out of the can after being shaken?
Accidentally deleted python and yum is not working in centos7
Ethical for a company to ask employees to move furniture on the weekend?
Creating a character, is Noble a class or a background?
Doing research in academia and not liking competition
pgfkeys: .store in constructed macro
Did 007 exist before James Bond?
Solr datatype for interval provided by postgresql
PostgreSQL “DESCRIBE TABLE”Show tables in PostgreSQLCreating a copy of a database in PostgreSQLHow can I drop all the tables in a PostgreSQL database?PostgreSQL: Difference between text and varchar (character varying)Import SQL dump into PostgreSQL databaseHow to exit from PostgreSQL command line utility: psqlSolr vs. ElasticSearchWhich version of PostgreSQL am I running?Indexing PostgreSQL BYTEA data with Solr & Tika
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have Apache solr 7.4.0 which is connected to a postgresql datasource to pull data and indexing it.
Now in SQL query we have date difference which is coming as "interval".
Now I have tried using "string" as well as "date" data type which is giving below error
"error creating documents" ....
here are my sql
select
a.opn_dt AS openDate,
a.clos_dt AS closeDate,
a.clos_dt - a.opn_dt AS Span from a;
and managed-schema where I have tried using data also
<field name="Span" type="string" indexed="false" stored="true" multiValued="false" default="" />
Please help how can I handle this "interval" value in managed-schema?
Thanks in advance
postgresql solr sqldatatypes
asked Mar 26 at 7:31
AliAli
11 bronze badge
add a comment |
I have Apache solr 7.4.0 which is connected to a postgresql datasource to pull data and indexing it.
Now in SQL query we have date difference which is coming as "interval".
Now I have tried using "string" as well as "date" data type which is giving below error
"error creating documents" ....
here are my sql
select
a.opn_dt AS openDate,
a.clos_dt AS closeDate,
a.clos_dt - a.opn_dt AS Span from a;
and managed-schema where I have tried using data also
<field name="Span" type="string" indexed="false" stored="true" multiValued="false" default="" />
Please help how can I handle this "interval" value in managed-schema?
Thanks in advance
postgresql solr sqldatatypes
asked Mar 26 at 7:31
AliAli
11 bronze badge
looks like its not a issue at the solr end, but the query needs to be corrected by using the postgresql functions...I would suggest to build the correct query by using functions from postgresql.org/docs/9.1/functions-datetime.html
– Abhijit Bashetti
Mar 26 at 12:29
the query in mysql is something like below select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(SECOND,now(),date_sub(now(), interval -3 hour)) from dual; OR select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(HOUR,now(),date_sub(now(), interval -3 hour)) from dual;
– Abhijit Bashetti
Mar 26 at 12:36
add a comment |
I have Apache solr 7.4.0 which is connected to a postgresql datasource to pull data and indexing it.
Now in SQL query we have date difference which is coming as "interval".
Now I have tried using "string" as well as "date" data type which is giving below error
"error creating documents" ....
here are my sql
select
a.opn_dt AS openDate,
a.clos_dt AS closeDate,
a.clos_dt - a.opn_dt AS Span from a;
and managed-schema where I have tried using data also
<field name="Span" type="string" indexed="false" stored="true" multiValued="false" default="" />
Please help how can I handle this "interval" value in managed-schema?
Thanks in advance
postgresql solr sqldatatypes
asked Mar 26 at 7:31
AliAli
11 bronze badge
I have Apache solr 7.4.0 which is connected to a postgresql datasource to pull data and indexing it.
Now in SQL query we have date difference which is coming as "interval".
Now I have tried using "string" as well as "date" data type which is giving below error
"error creating documents" ....
here are my sql
select
a.opn_dt AS openDate,
a.clos_dt AS closeDate,
a.clos_dt - a.opn_dt AS Span from a;
and managed-schema where I have tried using data also
<field name="Span" type="string" indexed="false" stored="true" multiValued="false" default="" />
Please help how can I handle this "interval" value in managed-schema?
Thanks in advance
postgresql solr sqldatatypes
postgresql solr sqldatatypes
asked Mar 26 at 7:31
AliAli
11 bronze badge
asked Mar 26 at 7:31
AliAli
11 bronze badge
asked Mar 26 at 7:31
AliAli
11 bronze badge
asked Mar 26 at 7:31
AliAli
11 bronze badge
asked Mar 26 at 7:31
AliAli
11 bronze badge
11 bronze badge
looks like its not a issue at the solr end, but the query needs to be corrected by using the postgresql functions...I would suggest to build the correct query by using functions from postgresql.org/docs/9.1/functions-datetime.html
– Abhijit Bashetti
Mar 26 at 12:29
the query in mysql is something like below select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(SECOND,now(),date_sub(now(), interval -3 hour)) from dual; OR select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(HOUR,now(),date_sub(now(), interval -3 hour)) from dual;
– Abhijit Bashetti
Mar 26 at 12:36
add a comment |
looks like its not a issue at the solr end, but the query needs to be corrected by using the postgresql functions...I would suggest to build the correct query by using functions from postgresql.org/docs/9.1/functions-datetime.html
– Abhijit Bashetti
Mar 26 at 12:29
the query in mysql is something like below select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(SECOND,now(),date_sub(now(), interval -3 hour)) from dual; OR select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(HOUR,now(),date_sub(now(), interval -3 hour)) from dual;
– Abhijit Bashetti
Mar 26 at 12:36
looks like its not a issue at the solr end, but the query needs to be corrected by using the postgresql functions...I would suggest to build the correct query by using functions from postgresql.org/docs/9.1/functions-datetime.html
– Abhijit Bashetti
Mar 26 at 12:29
looks like its not a issue at the solr end, but the query needs to be corrected by using the postgresql functions...I would suggest to build the correct query by using functions from postgresql.org/docs/9.1/functions-datetime.html
– Abhijit Bashetti
Mar 26 at 12:29
the query in mysql is something like below select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(SECOND,now(),date_sub(now(), interval -3 hour)) from dual; OR select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(HOUR,now(),date_sub(now(), interval -3 hour)) from dual;
– Abhijit Bashetti
Mar 26 at 12:36
the query in mysql is something like below select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(SECOND,now(),date_sub(now(), interval -3 hour)) from dual; OR select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(HOUR,now(),date_sub(now(), interval -3 hour)) from dual;
– Abhijit Bashetti
Mar 26 at 12:36
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%2f55351841%2fsolr-datatype-for-interval-provided-by-postgresql%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
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
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%2f55351841%2fsolr-datatype-for-interval-provided-by-postgresql%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
looks like its not a issue at the solr end, but the query needs to be corrected by using the postgresql functions...I would suggest to build the correct query by using functions from postgresql.org/docs/9.1/functions-datetime.html
– Abhijit Bashetti
Mar 26 at 12:29
the query in mysql is something like below select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(SECOND,now(),date_sub(now(), interval -3 hour)) from dual; OR select date_sub(now(), interval -3 hour) as past, now() as current, TIMESTAMPDIFF(HOUR,now(),date_sub(now(), interval -3 hour)) from dual;
– Abhijit Bashetti
Mar 26 at 12:36