[OODT-459] Filemgr Client Tool Doesn't Seem To Support Queries with WHERE Clauses Containing Multiple Conditions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 0.3
• Fix Version/s: 0.4
• Component/s: file manager
• Assignee: Brian Foster
• Reporter: Michael Cayanan
• Created: 21/May/12 17:13
• Updated: 21/May/12 23:51
• Resolved: 21/May/12 23:51

Description

The filemgr-client tool doesn't appear to support queries with WHERE clauses containing multiple conditions. To isolate the problem, I placed the command-line arguments inside the filemgr-client shell script:

org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient --url http://localhost:9000 -q "SELECT * FROM L0a_Radar WHERE RangeBeginningDate > '2007-01-01' AND RangeBeginningTime > '12:00:00.000'" -op -sql

The tool threw the following exception:

May 21, 2012 10:05:50 AM org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient <init>
INFO: Loading File Manager Configuration Properties from: [../etc/filemgr.properties]
org.apache.xmlrpc.XmlRpcException: java.lang.Exception: org.apache.oodt.cas.filemgr.structs.exceptions.CatalogException: Failed to perform complex query : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERSECT (SELECT DISTINCT product_id FROM L0a_Radar_metadata WHERE element_id =' at line 1
	at org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeException(XmlRpcClientResponseProcessor.java:104)
	at org.apache.xmlrpc.XmlRpcClientResponseProcessor.decodeResponse(XmlRpcClientResponseProcessor.java:71)
	at org.apache.xmlrpc.XmlRpcClientWorker.execute(XmlRpcClientWorker.java:73)
	at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:194)
	at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:185)
	at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:178)
	at org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient.complexQuery(XmlRpcFileManagerClient.java:990)
	at org.apache.oodt.cas.filemgr.cli.action.AbstractQueryCliAction.execute(AbstractQueryCliAction.java:75)
	at org.apache.oodt.cas.cli.CmdLineUtility.execute(CmdLineUtility.java:331)
	at org.apache.oodt.cas.cli.CmdLineUtility.run(CmdLineUtility.java:187)
	at org.apache.oodt.cas.filemgr.system.XmlRpcFileManagerClient.main(XmlRpcFileManagerClient.java:1323)
ERROR: Failed to perform sql query : sortBy 'null', outputFormat 'null', and delimiter '
', filterAlgor 'null', startDateTimeMetKey 'null', endDateTimeMetKey 'null', priorityMetKey 'null', null' : java.lang.Exception: org.apache.oodt.cas.filemgr.structs.exceptions.CatalogException: Failed to perform complex query : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERSECT (SELECT DISTINCT product_id FROM L0a_Radar_metadata WHERE element_id =' at line 1

This functionality will be needed for the SMAP mission.