Ufdjrw

High voltage LED indicator 40-1000 VDC without additional power supply

How do I deal with an unproductive colleague in a small company?

Why can't we play rap on piano?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

"You are your self first supporter", a more proper way to say it

Why is Minecraft giving an OpenGL error?

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

How is it possible to have an ability score that is less than 3?

Client team has low performances and low technical skills: we always fix their work and now they stop collaborate with us. How to solve?

Approximately how much travel time was saved by the opening of the Suez Canal in 1869?

Cross compiling for RPi - error while loading shared libraries

Today is the Center

Can a monk's single staff be considered dual wielded, as per the Dual Wielder feat?

Is it inappropriate for a student to attend their mentor's dissertation defense?

What's that red-plus icon near a text?

Important Resources for Dark Age Civilizations?

Alternative to sending password over mail?

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Modeling an IP Address

Can I make popcorn with any corn?

Do I have a twin with permutated remainders?

Can I ask the recruiters in my resume to put the reason why I am rejected?

Why doesn't H₄O²⁺ exist?

NMaximize is not converging to a solution

Syntax error: cannot recognize input near “ ” " in function specification

Reference - What does this error mean in PHP?LEAD function syntax in HIVE-QLHIVE: cannot recognize input near 'distinct' '('cannot recognize input near 'select' in subquerycannot recognize input near in hiveCannot recognize input near '|' 'sed' ''s/[[:space:]]+/,/g'' in table sourceError while compiling statement: FAILED: ParseException line 1:49 cannot recognize input near '(' 'stock_status_id' ',' in statementHive Query FAILED: ParseException line cannot recognize input near '(' 'WITH' 'DATA_SET' in select clausecannot recognize input near 'SELECT' 'DISTINCT' '(' in expression specification -HiveFAILED: ParseException line 1:36 cannot recognize input near '1987'

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I am running following hive query in qubole

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

Error I am getting:

Syntax Error: org.apache.hadoop.hive.ql.parse.ParseException: line 1:15 
 cannot recognize input near '' '' '' in function specification

I am not able to find much online to resolve this issue.

mysql sql hadoop hive hiveql

share|improve this question

edited Mar 8 at 18:23

zealous

asked Mar 8 at 1:47

zealouszealous

83

add a comment | 

0

I am running following hive query in qubole

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

Error I am getting:

Syntax Error: org.apache.hadoop.hive.ql.parse.ParseException: line 1:15 
 cannot recognize input near '' '' '' in function specification

I am not able to find much online to resolve this issue.

mysql sql hadoop hive hiveql

share|improve this question

edited Mar 8 at 18:23

zealous

asked Mar 8 at 1:47

zealouszealous

83

add a comment | 

I am running following hive query in qubole

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

Error I am getting:

Syntax Error: org.apache.hadoop.hive.ql.parse.ParseException: line 1:15 
 cannot recognize input near '' '' '' in function specification

I am not able to find much online to resolve this issue.

mysql sql hadoop hive hiveql

share|improve this question

edited Mar 8 at 18:23

zealous

asked Mar 8 at 1:47

zealouszealous

83

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

Syntax Error: org.apache.hadoop.hive.ql.parse.ParseException: line 1:15 
 cannot recognize input near '' '' '' in function specification

share|improve this question

edited Mar 8 at 18:23

zealous

asked Mar 8 at 1:47

zealouszealous

83

share|improve this question

edited Mar 8 at 18:23

zealous

asked Mar 8 at 1:47

zealouszealous

83

asked Mar 8 at 1:47

zealouszealous

83

asked Mar 8 at 1:47

zealouszealous

83

1 Answer
1

active

oldest

votes

0

I found a solution, to find special character (; - in my case) you have to put escape character in front of it. so following solution would work

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

share|improve this answer

answered Mar 8 at 18:41

zealouszealous

83

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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55055583%2fsyntax-error-cannot-recognize-input-near-in-function-specification%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I found a solution, to find special character (; - in my case) you have to put escape character in front of it. so following solution would work

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

share|improve this answer

answered Mar 8 at 18:41

zealouszealous

83

add a comment | 

0

I found a solution, to find special character (; - in my case) you have to put escape character in front of it. so following solution would work

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

share|improve this answer

answered Mar 8 at 18:41

zealouszealous

83

add a comment | 

I found a solution, to find special character (; - in my case) you have to put escape character in front of it. so following solution would work

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

share|improve this answer

answered Mar 8 at 18:41

zealouszealous

83

select locate(';', substring(tags, locate('Swimlane:', tags), 
 length(tags)))
from myTable

share|improve this answer

answered Mar 8 at 18:41

zealouszealous

83

answered Mar 8 at 18:41

zealouszealous

83

answered Mar 8 at 18:41

zealouszealous

83