[jira] Commented: (HIVE-1434) Cassandra Storage Handler
[ https://issues.apache.org/jira/browse/HIVE-1434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12898786#action_12898786 ] Amr Awadallah commented on HIVE-1434: - I am out of office on vacation and will be slower than usual in responding to emails. If this is urgent then please call my cell phone (or send an sms), otherwise I will reply to your email when I get back. Thanks for your patience, -- amr > Cassandra Storage Handler > - > > Key: HIVE-1434 > URL: https://issues.apache.org/jira/browse/HIVE-1434 > Project: Hadoop Hive > Issue Type: New Feature >Reporter: Edward Capriolo >Assignee: Edward Capriolo > Attachments: cas-handle.tar.gz, hive-1434-1.txt, > hive-1434-2-patch.txt, hive-1434-3-patch.txt, hive-1434-4-patch.txt > > > Add a cassandra storage handler. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1126) Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.
[ https://issues.apache.org/jira/browse/HIVE-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12893175#action_12893175 ] Amr Awadallah commented on HIVE-1126: - I am out of office on vacation and will be slower than usual in responding to emails. If this is urgent then please call my cell phone (or send an sms), otherwise I will reply to your email when I get back. Thanks for your patience, -- amr > Missing some Jdbc functionality like getTables getColumns and > HiveResultSet.get* methods based on column name. > -- > > Key: HIVE-1126 > URL: https://issues.apache.org/jira/browse/HIVE-1126 > Project: Hadoop Hive > Issue Type: Improvement > Components: Clients >Reporter: Bennie Schut >Assignee: Bennie Schut > Fix For: 0.7.0 > > Attachments: HIVE-1126-1.patch, HIVE-1126-2.patch, HIVE-1126-3.patch, > HIVE-1126-4.patch, HIVE-1126-5.patch, HIVE-1126-6.patch, HIVE-1126.patch, > HIVE-1126_patch(0.5.0_source).patch > > > I've been using the hive jdbc driver more and more and was missing some > functionality which I added > HiveDatabaseMetaData.getTables > Using "show tables" to get the info from hive. > HiveDatabaseMetaData.getColumns > Using "describe tablename" to get the columns. > This makes using something like SQuirreL a lot nicer since you have the list > of tables and just click on the content tab to see what's in the table. > I also implemented > HiveResultSet.getObject(String columnName) so you call most get* methods > based on the column name. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1126) Missing some Jdbc functionality like getTables getColumns and HiveResultSet.get* methods based on column name.
[ https://issues.apache.org/jira/browse/HIVE-1126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12891950#action_12891950 ] Amr Awadallah commented on HIVE-1126: - I am out of office on vacation and will be slower than usual in responding to emails. If this is urgent then please call my cell phone (or send an sms), otherwise I will reply to your email when I get back. Thanks for your patience, -- amr > Missing some Jdbc functionality like getTables getColumns and > HiveResultSet.get* methods based on column name. > -- > > Key: HIVE-1126 > URL: https://issues.apache.org/jira/browse/HIVE-1126 > Project: Hadoop Hive > Issue Type: Improvement > Components: Clients >Affects Versions: 0.7.0 >Reporter: Bennie Schut >Assignee: Bennie Schut > Fix For: 0.7.0 > > Attachments: HIVE-1126-1.patch, HIVE-1126-2.patch, HIVE-1126-3.patch, > HIVE-1126-4.patch, HIVE-1126-5.patch, HIVE-1126.patch, > HIVE-1126_patch(0.5.0_source).patch > > > I've been using the hive jdbc driver more and more and was missing some > functionality which I added > HiveDatabaseMetaData.getTables > Using "show tables" to get the info from hive. > HiveDatabaseMetaData.getColumns > Using "describe tablename" to get the columns. > This makes using something like SQuirreL a lot nicer since you have the list > of tables and just click on the content tab to see what's in the table. > I also implemented > HiveResultSet.getObject(String columnName) so you call most get* methods > based on the column name. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-78) Authorization infrastructure for Hive
[ https://issues.apache.org/jira/browse/HIVE-78?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12802720#action_12802720 ] Amr Awadallah commented on HIVE-78: --- I am also very curious what is latest on this jira, no updates since Sept of last year. Min, did you stop working on this? -- amr > Authorization infrastructure for Hive > - > > Key: HIVE-78 > URL: https://issues.apache.org/jira/browse/HIVE-78 > Project: Hadoop Hive > Issue Type: New Feature > Components: Server Infrastructure >Reporter: Ashish Thusoo >Assignee: Edward Capriolo > Attachments: createuser-v1.patch, hive-78-metadata-v1.patch, > hive-78-syntax-v1.patch, hive-78.diff > > > Allow hive to integrate with existing user repositories for authentication > and authorization infromation. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Created: (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive. --- Key: HIVE-896 URL: https://issues.apache.org/jira/browse/HIVE-896 Project: Hadoop Hive Issue Type: New Feature Reporter: Amr Awadallah Priority: Minor Windowing functions are very useful for click stream processing and similar time-series/sliding-window analytics. More details at: http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1006709 http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1007059 http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analysis.htm#i1007032 -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740479#action_12740479 ] Amr Awadallah commented on HIVE-344: unfortunately HIVE_LIB is checked for validity inside these files using normal bash commands, so the cygpath translation for HIVE_LIB has to be done this late as opposed to in the main hive script (otherwise the verification in sub-scripts would fail). > Fix the Hive CLI to run on cygwin under windows > --- > > Key: HIVE-344 > URL: https://issues.apache.org/jira/browse/HIVE-344 > Project: Hadoop Hive > Issue Type: Bug > Components: Clients >Affects Versions: 0.3.0 >Reporter: Amr Awadallah >Assignee: Amr Awadallah > Fix For: 0.3.1 > > Attachments: HIVE-344-v2.patch, HIVE-344.patch > > > Yes, I am guilty as charged, I don't use mac like the rest of you :) > The Hive CLI currently doesn't work with cygwin under windows, this is due to > the dual path model that cygwin employs (there are file paths relative to the > cygwin virtual root, and file paths relative to the windows root) > Since Sun's JDK is installed under the windows environment, if the paths are > not converted to windows format before being passed along then java will be > at a loss to where the files are. The solution is to use the cygpath command > to convert the paths to windows format before passing along to java world. > I have a fix for this already, still doing some further testing (to make sure > it works under both unix and windows environments), then I will submit patch > to this bug (should submit before end of this week). > Cheers, > -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12738777#action_12738777 ] Amr Awadallah commented on HIVE-344: ashish, worked? > Fix the Hive CLI to run on cygwin under windows > --- > > Key: HIVE-344 > URL: https://issues.apache.org/jira/browse/HIVE-344 > Project: Hadoop Hive > Issue Type: Bug > Components: Clients >Affects Versions: 0.3.0 >Reporter: Amr Awadallah >Assignee: Amr Awadallah > Fix For: 0.3.1 > > Attachments: HIVE-344-v2.patch, HIVE-344.patch > > > Yes, I am guilty as charged, I don't use mac like the rest of you :) > The Hive CLI currently doesn't work with cygwin under windows, this is due to > the dual path model that cygwin employs (there are file paths relative to the > cygwin virtual root, and file paths relative to the windows root) > Since Sun's JDK is installed under the windows environment, if the paths are > not converted to windows format before being passed along then java will be > at a loss to where the files are. The solution is to use the cygpath command > to convert the paths to windows format before passing along to java world. > I have a fix for this already, still doing some further testing (to make sure > it works under both unix and windows environments), then I will submit patch > to this bug (should submit before end of this week). > Cheers, > -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amr Awadallah updated HIVE-344: --- Attachment: HIVE-344-v2.patch @Ashish Can't believe it has been two months already, but please find a new patch attached (HIVE-344-v2.patch). I think I tracked down all places where AUX_PARAM and AUX_CLASSPATH get set. Please give a try and let me know. Cheers, -- amr > Fix the Hive CLI to run on cygwin under windows > --- > > Key: HIVE-344 > URL: https://issues.apache.org/jira/browse/HIVE-344 > Project: Hadoop Hive > Issue Type: Bug > Components: Clients >Affects Versions: 0.3.0 >Reporter: Amr Awadallah >Assignee: Amr Awadallah > Fix For: 0.3.2 > > Attachments: HIVE-344-v2.patch, HIVE-344.patch > > > Yes, I am guilty as charged, I don't use mac like the rest of you :) > The Hive CLI currently doesn't work with cygwin under windows, this is due to > the dual path model that cygwin employs (there are file paths relative to the > cygwin virtual root, and file paths relative to the windows root) > Since Sun's JDK is installed under the windows environment, if the paths are > not converted to windows format before being passed along then java will be > at a loss to where the files are. The solution is to use the cygpath command > to convert the paths to windows format before passing along to java world. > I have a fix for this already, still doing some further testing (to make sure > it works under both unix and windows environments), then I will submit patch > to this bug (should submit before end of this week). > Cheers, > -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12713395#action_12713395 ] Amr Awadallah commented on HIVE-344: @Ashish, sorry for delay replying and thanks for testing. I thought I tracked down all of the path params, I will take a closer look at AUX_PARAMS next week and submit another patch. -- amr > Fix the Hive CLI to run on cygwin under windows > --- > > Key: HIVE-344 > URL: https://issues.apache.org/jira/browse/HIVE-344 > Project: Hadoop Hive > Issue Type: Bug > Components: Clients >Affects Versions: 0.3.0 >Reporter: Amr Awadallah >Assignee: Amr Awadallah > Fix For: 0.3.1 > > Attachments: HIVE-344.patch > > > Yes, I am guilty as charged, I don't use mac like the rest of you :) > The Hive CLI currently doesn't work with cygwin under windows, this is due to > the dual path model that cygwin employs (there are file paths relative to the > cygwin virtual root, and file paths relative to the windows root) > Since Sun's JDK is installed under the windows environment, if the paths are > not converted to windows format before being passed along then java will be > at a loss to where the files are. The solution is to use the cygpath command > to convert the paths to windows format before passing along to java world. > I have a fix for this already, still doing some further testing (to make sure > it works under both unix and windows environments), then I will submit patch > to this bug (should submit before end of this week). > Cheers, > -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amr Awadallah updated HIVE-344: --- Attachment: HIVE-344.patch > Fix the Hive CLI to run on cygwin under windows > --- > > Key: HIVE-344 > URL: https://issues.apache.org/jira/browse/HIVE-344 > Project: Hadoop Hive > Issue Type: Bug > Components: Clients >Affects Versions: 0.3.0 >Reporter: Amr Awadallah > Fix For: 0.3.0 > > Attachments: HIVE-344.patch > > > Yes, I am guilty as charged, I don't use mac like the rest of you :) > The Hive CLI currently doesn't work with cygwin under windows, this is due to > the dual path model that cygwin employs (there are file paths relative to the > cygwin virtual root, and file paths relative to the windows root) > Since Sun's JDK is installed under the windows environment, if the paths are > not converted to windows format before being passed along then java will be > at a loss to where the files are. The solution is to use the cygpath command > to convert the paths to windows format before passing along to java world. > I have a fix for this already, still doing some further testing (to make sure > it works under both unix and windows environments), then I will submit patch > to this bug (should submit before end of this week). > Cheers, > -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
[ https://issues.apache.org/jira/browse/HIVE-344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amr Awadallah updated HIVE-344: --- Fix Version/s: 0.3.0 Affects Version/s: 0.3.0 Release Note: * Fixes for running hive under cygwin Status: Patch Available (was: Open) I upgraded the fix to work with Hive 0.3. Would be great if a couple of folks can try this under cygwin and let me know if it works fine. It shouldn't affect non-windows installations, and for windows installations it will change the relevant paths/dirs using cygpath (I added the fix to all services: cli.sh, hwi.sh, hiveserver.sh, and lineage.sh) > Fix the Hive CLI to run on cygwin under windows > --- > > Key: HIVE-344 > URL: https://issues.apache.org/jira/browse/HIVE-344 > Project: Hadoop Hive > Issue Type: Bug > Components: Clients >Affects Versions: 0.3.0 >Reporter: Amr Awadallah > Fix For: 0.3.0 > > > Yes, I am guilty as charged, I don't use mac like the rest of you :) > The Hive CLI currently doesn't work with cygwin under windows, this is due to > the dual path model that cygwin employs (there are file paths relative to the > cygwin virtual root, and file paths relative to the windows root) > Since Sun's JDK is installed under the windows environment, if the paths are > not converted to windows format before being passed along then java will be > at a loss to where the files are. The solution is to use the cygpath command > to convert the paths to windows format before passing along to java world. > I have a fix for this already, still doing some further testing (to make sure > it works under both unix and windows environments), then I will submit patch > to this bug (should submit before end of this week). > Cheers, > -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-420) Support regular expressions for column in select clause
[
https://issues.apache.org/jira/browse/HIVE-420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12705198#action_12705198
]
Amr Awadallah commented on HIVE-420:
@Zheng, good point, they are indeed redundant for match.
> Support regular expressions for column in select clause
> ---
>
> Key: HIVE-420
> URL: https://issues.apache.org/jira/browse/HIVE-420
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
>Affects Versions: 0.2.0, 0.3.0, 0.3.1, 0.4.0
>Reporter: Prasad Chakka
>Assignee: Zheng Shao
>Priority: Minor
> Fix For: 0.4.0
>
> Attachments: HIVE-420.1.patch, HIVE-420.2.patch, HIVE-420.3.patch,
> HIVE-420.4.patch
>
>
> support queries like {code} select a.`(ds|hr)?+.+` from a where
> a.ds='2009-09-09' {code} which are useful when there are humongous number of
> columns in a table and want to select all columns except the partition
> columns (ds and hr).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-420) Support regular expressions for column in select clause
[ https://issues.apache.org/jira/browse/HIVE-420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12705127#action_12705127 ] Amr Awadallah commented on HIVE-420: Very cool feature. BTW, for this comment: https://issues.apache.org/jira/browse/HIVE-420?focusedCommentId=12704795&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12704795 the regex is missing a ^ > Support regular expressions for column in select clause > --- > > Key: HIVE-420 > URL: https://issues.apache.org/jira/browse/HIVE-420 > Project: Hadoop Hive > Issue Type: New Feature > Components: Query Processor >Affects Versions: 0.2.0, 0.3.0, 0.3.1, 0.4.0 >Reporter: Prasad Chakka >Assignee: Zheng Shao >Priority: Minor > Fix For: 0.4.0 > > Attachments: HIVE-420.1.patch, HIVE-420.2.patch, HIVE-420.3.patch, > HIVE-420.4.patch > > > support queries like `select a.[^ds] from a where a.ds='2009-09-09'` which > are useful when there are humongous number of columns in a table and want to > select all columns except the partitions columns. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Created: (HIVE-344) Fix the Hive CLI to run on cygwin under windows
Fix the Hive CLI to run on cygwin under windows --- Key: HIVE-344 URL: https://issues.apache.org/jira/browse/HIVE-344 Project: Hadoop Hive Issue Type: Bug Components: Clients Reporter: Amr Awadallah Yes, I am guilty as charged, I don't use mac like the rest of you :) The Hive CLI currently doesn't work with cygwin under windows, this is due to the dual path model that cygwin employs (there are file paths relative to the cygwin virtual root, and file paths relative to the windows root) Since Sun's JDK is installed under the windows environment, if the paths are not converted to windows format before being passed along then java will be at a loss to where the files are. The solution is to use the cygpath command to convert the paths to windows format before passing along to java world. I have a fix for this already, still doing some further testing (to make sure it works under both unix and windows environments), then I will submit patch to this bug (should submit before end of this week). Cheers, -- amr -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
