compare date() to string in hive query builder but not in beeline2019 Community Moderator ElectionHow does impala provide faster query response compared to hivebeeline equivalent of hive silent modeSet date function as variable and use in beeline and hql file (hive)query works in Hive 1.x but not in beelinebeeline and hive queries in metastore tablesSet Variable to Query Dynamically Through BeelineHive query fails in spark, but works in beeline HiveUnexpected behaviour in Hive queries with date comparisonsdate time comparisons in hive sqlWhat is path for hive beeline command history file?
The bar has been raised
Examples of a statistic that is not independent of sample's distribution?
Built-In Shelves/Bookcases - IKEA vs Built
Is there a window switcher for GNOME that shows the actual window?
Why does Captain Marvel assume the people on this planet know this?
What is the chance of making a successful appeal to dismissal decision from a PhD program after failing the qualifying exam in the 2nd attempt?
What does a stand alone "T" index value do?
How much attack damage does the AC boost from a shield prevent on average?
Grey hair or white hair
Making a sword in the stone, in a medieval world without magic
Time travel short story where dinosaur doesn't taste like chicken
Why is there a voltage between the mains ground and my radiator?
How could our ancestors have domesticated a solitary predator?
Peter's Strange Word
Why is this plane circling around the Lucknow airport every day?
Can Mathematica be used to create an Artistic 3D extrusion from a 2D image and wrap a line pattern around it?
Latest web browser compatible with Windows 98
Is "history" a male-biased word ("his+story")?
Offered promotion but I'm leaving. Should I tell?
Replacing Windows 7 security updates with anti-virus?
Can you reject a postdoc offer after the PI has paid a large sum for flights/accommodation for your visit?
Make a transparent 448*448 image
infinitive telling the purpose
Force user to remove USB token
compare date() to string in hive query builder but not in beeline
2019 Community Moderator ElectionHow does impala provide faster query response compared to hivebeeline equivalent of hive silent modeSet date function as variable and use in beeline and hql file (hive)query works in Hive 1.x but not in beelinebeeline and hive queries in metastore tablesSet Variable to Query Dynamically Through BeelineHive query fails in spark, but works in beeline HiveUnexpected behaviour in Hive queries with date comparisonsdate time comparisons in hive sqlWhat is path for hive beeline command history file?
How is that,I am able to compare date() to string in hive query builder but not in beeline?
Example.
where date(timestamp) = '2019-..-..'
is working in query builder and not in beeline
hive
edited Mar 6 at 16:51
VK_217
7,75252247
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
How is that,I am able to compare date() to string in hive query builder but not in beeline?
Example.
where date(timestamp) = '2019-..-..'
is working in query builder and not in beeline
hive
edited Mar 6 at 16:51
VK_217
7,75252247
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
could you tryto_date()
– Gaurang Shah
Mar 6 at 17:06
to_date() is fine, my concern is, as we cannot compare date() with string, then how is this working?
– Ashima Sood
Mar 6 at 20:12
add a comment |
How is that,I am able to compare date() to string in hive query builder but not in beeline?
Example.
where date(timestamp) = '2019-..-..'
is working in query builder and not in beeline
hive
edited Mar 6 at 16:51
VK_217
7,75252247
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
How is that,I am able to compare date() to string in hive query builder but not in beeline?
Example.
where date(timestamp) = '2019-..-..'
is working in query builder and not in beeline
hive
hive
edited Mar 6 at 16:51
VK_217
7,75252247
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 6 at 16:51
VK_217
7,75252247
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 6 at 16:51
VK_217
7,75252247
edited Mar 6 at 16:51
VK_217
7,75252247
edited Mar 6 at 16:51
VK_217
7,75252247
7,75252247
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
asked Mar 6 at 16:19
Ashima SoodAshima Sood
31
31
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Ashima Sood is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
could you tryto_date()
– Gaurang Shah
Mar 6 at 17:06
to_date() is fine, my concern is, as we cannot compare date() with string, then how is this working?
– Ashima Sood
Mar 6 at 20:12
add a comment |
could you tryto_date()
– Gaurang Shah
Mar 6 at 17:06
to_date() is fine, my concern is, as we cannot compare date() with string, then how is this working?
– Ashima Sood
Mar 6 at 20:12
could you try
to_date()– Gaurang Shah
Mar 6 at 17:06
could you try
to_date()– Gaurang Shah
Mar 6 at 17:06
to_date() is fine, my concern is, as we cannot compare date() with string, then how is this working?
– Ashima Sood
Mar 6 at 20:12
to_date() is fine, my concern is, as we cannot compare date() with string, then how is this working?
– Ashima Sood
Mar 6 at 20:12
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
);
);
Ashima Sood is a new contributor. Be nice, and check out our Code of Conduct.
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%2f55027690%2fcompare-date-to-string-in-hive-query-builder-but-not-in-beeline%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
Ashima Sood is a new contributor. Be nice, and check out our Code of Conduct.
Ashima Sood is a new contributor. Be nice, and check out our Code of Conduct.
Ashima Sood is a new contributor. Be nice, and check out our Code of Conduct.
Ashima Sood is a new contributor. Be nice, and check out our Code of Conduct.
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%2f55027690%2fcompare-date-to-string-in-hive-query-builder-but-not-in-beeline%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
could you try
to_date()– Gaurang Shah
Mar 6 at 17:06
to_date() is fine, my concern is, as we cannot compare date() with string, then how is this working?
– Ashima Sood
Mar 6 at 20:12