You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Edward Yoon (JIRA)" <ji...@apache.org> on 2007/12/29 12:46:43 UTC
[jira] Created: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
[Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
-----------------------------------------------------------------
Key: HADOOP-2502
URL: https://issues.apache.org/jira/browse/HADOOP-2502
Project: Hadoop
Issue Type: Improvement
Components: contrib/hbase
Affects Versions: 0.16.0
Environment: All
Reporter: Edward Yoon
Assignee: Edward Yoon
Fix For: 0.16.0
Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2502:
--------------------------------
Status: Patch Available (was: Open)
submitting.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2502.patch
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12555787#action_12555787 ]
stack commented on HADOOP-2502:
-------------------------------
+1 on implementing TIMESTAMP first Edward (Does the JarCommand memo belong in this issue?).
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12555496#action_12555496 ]
Edward Yoon commented on HADOOP-2502:
-------------------------------------
It is a current grammars.
But, [TIMESTAMP 'timestamp' ] not implemented.
{code}
INSERT INTO table_name (colmn_name, ...)
VALUES ('value', ...)
WHERE row = 'row-key'
[TIMESTAMP 'timestamp'];
SELECT { column_name [, column_name] ... | * }
FROM table_name
[WHERE row = 'row-key' | STARTING FROM 'row-key']
[NUM_VERSIONS = version_count]
[TIMESTAMP 'timestamp']
[LIMIT = row_count]
[INTO FILE 'file_name']
{code}
Let's do it, firstly.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-2502:
--------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
Committed (Failed in old-reliable TTMR). Closing. Thanks for the patch Edward.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2502.patch
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12556367#action_12556367 ]
Edward Yoon commented on HADOOP-2502:
-------------------------------------
{code}
build.xml
<mkdir dir="${hbaseshell.src.dir}/algebra/generated"/>
...
<javacc
target="${hbaseshell.src.dir}/algebra/ExpressionParser.jj"
outputdirectory="${hbaseshell.src.dir}/algebra/generated"
javacchome="${javacc.home}"
/>
{code}
Also, These code should be removed.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12554958 ]
stack commented on HADOOP-2502:
-------------------------------
This sounds like a good idea Edward. Can you supply examples that would illustrate how you think this should work?
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12555055 ]
Edward Yoon commented on HADOOP-2502:
-------------------------------------
All is timestamp.
But, Sometimes we might need a convert function as a timestamp to string or string to timestamp.
Because we are human.
So, Make a function package.
And, i'd like to make a 'DateTimeFormats' system table when system initializing.
Then, user can insert/select own date format style for converting.
Otherwise, just hard coding.
Anyhow, it also will be a good util for users.
Grammars are simiple.
I'd like to some copy the common SQL syntax.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12555765#action_12555765 ]
Edward Yoon commented on HADOOP-2502:
-------------------------------------
Memo :
{code}
JarCommand jarCommand() :
{
Token t = null;
JarCommand jar = new JarCommand(this.out);
List<String> query = new ArrayList<String>();
}
{
<JAR>
(
( t=<ID> | t=<INTEGER_LITERAL> | t=<FLOATING_POINT_LITERAL> )
{ query.add(t.image.toString()); }
)*
{
jar.setQuery(query);
return jar;
}
}
{code}
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12555804#action_12555804 ]
Edward Yoon commented on HADOOP-2502:
-------------------------------------
Thanks, micael.
JarCommand should be updated because it doesn't work now.
I missed it when 'algebra package' removing.
But, it is a trivial change, so i'd like to add to 2502.patch.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2502:
--------------------------------
Attachment: 2502.patch
- added a timestamp options.
- above code removed from build.xml
- some trivial code changes.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2502.patch
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12555057 ]
Edward Yoon commented on HADOOP-2502:
-------------------------------------
or... ('HH:II:SS', '12:02:32') instead of formats data.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2502) [Hbase Shell] Insert/Select
timestamp, Timestamp data type in HQL
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12556497#action_12556497 ]
Hadoop QA commented on HADOOP-2502:
-----------------------------------
-1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12372581/2502.patch
against trunk revision .
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests -1. The patch failed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1495/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1495/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1495/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1495/console
This message is automatically generated.
> [Hbase Shell] Insert/Select timestamp, Timestamp data type in HQL
> -----------------------------------------------------------------
>
> Key: HADOOP-2502
> URL: https://issues.apache.org/jira/browse/HADOOP-2502
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Environment: All
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2502.patch
>
>
> Current Insert/Select commands can't flexible handle the date.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.