how to know max length of sql that hive support?Is there maximum size of string data type in Hive?national language supported sort in HiveCan I insert data into table in Hive similar as in SQL?how to read partition keys from existing hive tableIssue Hive AvroSerDe tblProperties max lengthHive Supporting Unicode CharactersDatediff in HIVE with SQL supportHow to handle new line characters in hive?Hive Regex variable length fileSqoop import sql table into HiveHive: Create table from text file. Handle special character
How could an animal "smell" carbon monoxide?
(Piano) is the purpose of sheet music to be played along to? Or a guide for learning and reference during playing?
Sankhara meditation
License validity of unreleased project
Credit card details stolen every 1-2 years. What am I doing wrong?
Can a pizza stone be fixed after soap has been used to clean it?
Link of a singularity
Is it OK to use personal email ID for faculty job applications or should we use (current) institute's ID
Cauchy reals and Dedekind reals satisfy "the same mathematical theorems"
What could be reasoning of male prison in VR world to only allow undershirt and sarong as nightwear to male prisoners
What exactly is a Hadouken?
How to delete certain lists from a nested list?
How can I find what program is preventing my Mac from going to sleep?
Can I remove the doors before installing a sliding patio doors frame?
How could a medieval fortress manage large groups of migrants and travelers?
Kepler space telescope planets detection
Do I need a 50/60Hz notch filter for battery powered devices?
When does Fisher's "go get more data" approach make sense?
Why doesn't philosophy have higher standards for its arguments?
Alphanumeric Line and Curve Counting
Did Voldemort kill his father before finding out about Horcruxes?
Snaking a clogged tub drain
Why do candidates not quit if they no longer have a realistic chance to win in the 2020 US presidents election
Why does "git status" show I'm on the master branch and "git branch" does not?
how to know max length of sql that hive support?
Is there maximum size of string data type in Hive?national language supported sort in HiveCan I insert data into table in Hive similar as in SQL?how to read partition keys from existing hive tableIssue Hive AvroSerDe tblProperties max lengthHive Supporting Unicode CharactersDatediff in HIVE with SQL supportHow to handle new line characters in hive?Hive Regex variable length fileSqoop import sql table into HiveHive: Create table from text file. Handle special character
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I want to insert some data into hive.
under some limits I have to use insert. I can not use load local data ...
INSERT into (DATABASE)::(TABLE) values (a1,b1,c1,d1),(a2,b2,c2,d2) ...
The question is:
some field is very long string , like article content, I have use base64 to handle special characters, now I am looking for the max length that hive-sql support.
hive hiveql
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
add a comment |
I want to insert some data into hive.
under some limits I have to use insert. I can not use load local data ...
INSERT into (DATABASE)::(TABLE) values (a1,b1,c1,d1),(a2,b2,c2,d2) ...
The question is:
some field is very long string , like article content, I have use base64 to handle special characters, now I am looking for the max length that hive-sql support.
hive hiveql
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
STRINGis 2GB Reference: stackoverflow.com/questions/35030936/…
– faizulhaque
Mar 26 at 8:12
@faizulhaque I just want to know hive-sql max statement length
– Z.Lun
Mar 26 at 8:32
If MySQL is being used as MetaStore of Hive than the limit is max_allowed_packet=1048576 (1MB) and it's derby (default) than it has no limit (not sure)
– faizulhaque
Mar 27 at 10:00
add a comment |
I want to insert some data into hive.
under some limits I have to use insert. I can not use load local data ...
INSERT into (DATABASE)::(TABLE) values (a1,b1,c1,d1),(a2,b2,c2,d2) ...
The question is:
some field is very long string , like article content, I have use base64 to handle special characters, now I am looking for the max length that hive-sql support.
hive hiveql
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
I want to insert some data into hive.
under some limits I have to use insert. I can not use load local data ...
INSERT into (DATABASE)::(TABLE) values (a1,b1,c1,d1),(a2,b2,c2,d2) ...
The question is:
some field is very long string , like article content, I have use base64 to handle special characters, now I am looking for the max length that hive-sql support.
hive hiveql
hive hiveql
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
asked Mar 26 at 8:05
Z.LunZ.Lun
521 silver badge10 bronze badges
521 silver badge10 bronze badges
STRINGis 2GB Reference: stackoverflow.com/questions/35030936/…
– faizulhaque
Mar 26 at 8:12
@faizulhaque I just want to know hive-sql max statement length
– Z.Lun
Mar 26 at 8:32
If MySQL is being used as MetaStore of Hive than the limit is max_allowed_packet=1048576 (1MB) and it's derby (default) than it has no limit (not sure)
– faizulhaque
Mar 27 at 10:00
add a comment |
STRINGis 2GB Reference: stackoverflow.com/questions/35030936/…
– faizulhaque
Mar 26 at 8:12
@faizulhaque I just want to know hive-sql max statement length
– Z.Lun
Mar 26 at 8:32
If MySQL is being used as MetaStore of Hive than the limit is max_allowed_packet=1048576 (1MB) and it's derby (default) than it has no limit (not sure)
– faizulhaque
Mar 27 at 10:00
STRING is 2GB Reference: stackoverflow.com/questions/35030936/…– faizulhaque
Mar 26 at 8:12
STRING is 2GB Reference: stackoverflow.com/questions/35030936/…– faizulhaque
Mar 26 at 8:12
@faizulhaque I just want to know hive-sql max statement length
– Z.Lun
Mar 26 at 8:32
@faizulhaque I just want to know hive-sql max statement length
– Z.Lun
Mar 26 at 8:32
If MySQL is being used as MetaStore of Hive than the limit is max_allowed_packet=1048576 (1MB) and it's derby (default) than it has no limit (not sure)
– faizulhaque
Mar 27 at 10:00
If MySQL is being used as MetaStore of Hive than the limit is max_allowed_packet=1048576 (1MB) and it's derby (default) than it has no limit (not sure)
– faizulhaque
Mar 27 at 10:00
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%2f55352373%2fhow-to-know-max-length-of-sql-that-hive-support%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%2f55352373%2fhow-to-know-max-length-of-sql-that-hive-support%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
STRINGis 2GB Reference: stackoverflow.com/questions/35030936/…– faizulhaque
Mar 26 at 8:12
@faizulhaque I just want to know hive-sql max statement length
– Z.Lun
Mar 26 at 8:32
If MySQL is being used as MetaStore of Hive than the limit is max_allowed_packet=1048576 (1MB) and it's derby (default) than it has no limit (not sure)
– faizulhaque
Mar 27 at 10:00